> SELECT T1.COLUMN, T2.COLUMN
> FROM TABLE1 T1, TABLE2 T2
> WHERE T1.COLUMN *= T2.COLUMN
Sorry about the fist one. New web mail client...
Anyway, if I understand what you're saying, I believe what you want is an OUTER
JOIN.
SELECT T1.COLUMN, T2.COLUMN
FROM TABLE2 T2
outer join TABLE1 T1 on T2.COLUMN = T1.COLUMN
That will get all rows from T2, and matching rows from T1. If no row in T1
exists, then T1.COLUMN will be null.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
