Re: question about a select statement

The "minus" will work.
I.E.
select column A from table 1
minus select column A from table 2 ;

It will do what you've asked, but not more.

HTH
   James

In article <35807EEA.69BE_at_indy.net>, mmeadows_at_indy.net wrote:

>Suppose I have 2 tables.
>
>Table 1 & Table 2 have the same columns: column A & column B.
>
>What select command can I use to find all of the instances of
>Column A that are in Table 1 but not Table 2?
>
>Thanks,
>Martin Meadows

--

lorenzen_at_tiny.net             | Life is complex; it has
                              |   real and imaginary parts