Hello,
I have a database with 4 tables that are linked with keys. I want to make a query where I can search an ID and gives me all the information from all the tables for that ID.
The problem is that not all ID's have records for all tables. I have found that my query only provides me a result if it has existing records for all tables. How can I make it so that it just gives me all available/existing information?
Can I do this without going into VBA?
Thanks.