>I need to combine table A with table B into table C. Both tables have the following fields in common: Year, Borrower, Period, Rownum, and exchange(which is named "e" in table A and "en" in table B). The trick is I have to match records from table A with table B into each record in table C and I also have to include the records in both tables that do not match. Can I do this with one SQL command? If anyone can help me, thanks in advance.
>
>Michael E. Harris
Michael,
SELECT TableA.*, TableB.* ;
FROM TableA FULL OUTER JOIN TableB ;
ON TableA.Year = TabelB.Year ;
AND TableA.Borrower = TableB.Borrower ;
AND TableA.Period = TableB.Period ;
AND TableA.RowNum = TableB.RowNum ;
AND TableA.e = TableB.En ;
INTO TABLE TableC