Multi Table View

I am creating a multi-table view. Table1 joined to Table2 by ID field, it is a one to one match, also I want to join table3 to table1 by SALESID, but not all records in Table1 will have a matching record in Table3, but I want to return all records in Table1. I am a little confused on the Union Select statement when you have 3 tables. Any help with the correct syntax would be greatly appreciated?

Thankx,

Mitchell, Received on Fri Mar 11 2005 - 21:47:46 CST