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