Re: question about a select statement

Martin,

Try this:

Select a,b from Table1
MINUS
Select a,b from Table2;

Martin Meadows <mmeadows_at_indy.net> schrijfbewerkingen:
> 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
Received on Fri Jun 12 1998 - 03:59:30 CDT