Query records from multiple tables and include records not mentioned on other tables

[Ganymede]

Sorry for the awkward title. Let me try to articulate this differently. I want to run a query for records from two tables: subpoenas and receivables. Some of the records on the subpoenas table have a corresponding record (matching key #) on receivables table. Thus, for those records, I want to include the respective invoice numbers on the query report. However, many of the records in subpoenas do not have corresponding records on receivables. I want to include those records in the query as well. However, the minute I bring the receivables table on the query, the data is immediately limited to records present on both tables. Thus, records on the subpoenas table that do not have a corresponding record on the receivables table are omitted from the query. Is there a way around this? Can I design the query to include the records from the subpoenas table that do not have corresponding records in the invoice table?

[pbaldy]

Right click on the join line between the tables to edit the join. Choose the correct "Include all records from..." option. That will change the join in SQL view from INNER to RIGHT or LEFT as appropriate to your selection.

[Ganymede]

Right click on the join line between the tables to edit the join. Choose the correct "Include all records from..." option. That will change the join in SQL view from INNER to RIGHT or LEFT as appropriate to your selection.

That did it! Thank you.

[pbaldy]

No problemo!