Hello John,

Try using this:

-------------
SELECT a.table_nm, a.field_nm, b.table_nm, b.field_nm ;
from TableA a FULL OUTER JOIN TableB b ON a.table_nm = b.table_nm ;
and a.field_nm = b.field_nm
-------------

Check the ouput of this query. You will get easily what all you want.


---
Raj