SELECT Table1.*, Table2.* ;
FROM Table1 FULLJOIN Table2 ON Table1.SomeKey = Table2.SomeKey ;
ORDERBY SomeField
>>If you used SQL with a FULL JOIN for your report you could check for NULLs in the parent part of the record. >Hi Cindy and yes I see the value of built-in referential integrity. >Could you send me a small sample of code of how to use SQL with a FULL JOIN.