Re: a select statement question

Why you don't try something like this:

select field_x, field_y, field_n from table1 Alias_1 where
Alias_1.key_field not in

    (select Alias_2.key_field from table2 Alias_2 where

                 Alias_2.key_field = Alias_1.key_field)

this gives you the same result using the NOT IN operator instead of the MINUS operator between two selects. Received on Thu Jun 18 1998 - 12:18:37 CDT