Re: emulate Outer join

Hi!
I have seen something like:

SELECT ......
FROM table_a a, table_b b
WHERE a.col1=b.col1
UNION
SELECT ......
FROM table_a a
WHERE a.col1 NOT IN

      (SELECT b.col1 FROM table_b b)
;

Even though we don't like ...NOT IN...
Frank Received on Mon Apr 02 2001 - 16:07:19 CDT