I have multiple tables that I am querying to combine a list of all data for a project. I realized that i am missing records if one of the tables does not have any information listed for the project. I would still like to show all the other data from the other tables and leave the field that had no value blank.
Attached is the Database. I am working on the "Project Query". The tables that may not have any details for a project at a specific point in time are the "Oracle Extract" and "Expense"