I know the queries work to take data that matches up, and the table with the least rows set up the format for the query.
Is there a way to have it so that the table with the most rows shows up entirely and any parts that have no matching data in other tables shows up empty?
Example:
Table 1 has 1000 rows of data
Table 2 has 500 rows of data
I want a query that will have 1000 rows with the fields specified from 1 and 2, and the 500 rows that are not in 2 will just show up blank.
I have a query that pulls in from at least 8 tables and I started off with 20,000+ entries and now I have 702... how can I get back to the 20,000+?
Thanks!