Re: SQL challenge;-)

On Thu, 3 May 2001, fh_at_energotec.de wrote:

> SELECT <column> FROM <table1> WHERE <column> NOT IN (SELECT
> <column> FROM <table2>);

select test1.fld1, test2.fld1
from test1,test2
where test1.fld1 = test2.fld1 (+)
and test2.fld1 IS NULL
;

If you do this query, you might find it to work faster, but haven't tested this theory in awhile.

-- 
Galen
I don't want to be the rock.  Yeah, okay, what do you want to be?
I want to be the piece of glass.