I have an Access 2002 database.
In the database contains 3 tables: CE, CEM and SUPP
In my query, I want all records from all 3 tables (even if there are no matching record keys) so that then end result would include all records.
See query here:
See SQL view here:
See CE-CEM join properties here:
See CEM-SUPP join properties here:
The results of my current query only includes records that are equal in the CE Table & CEM Table & SUPP Table.
I would like the query to produce all records from the CE table, all records from the CEM table and all records from the SUPP table.
Thank you for your help!