At 9:38 AM -0600 8/27/01, Jeff Shipman - SysProg wrote:
>I have two tables and that have a couple of
>identical columns. I would like to find out
>what of a certain column is in one table and
>not in another. I've tried the following, but
>I get errors:
>
>select col1 from tab1 where col1 not in (
Jeff,
If the result table from the inner select is not huge, I usually issue the
inner query by itself first, then build (in my scripting language of choice)
a comma-delimited text field containing the results that I don't want in my
final table. I then expand that text field into the 'NOT IN' c
