Query from 2 tables

[jstrain]

I have a main table where address information is stored and a linked table where financial transactions are stored. I did a query looking for people in the main table with certain types of information in the financial table. This works fine. However, I also want to see people in the first table who fit other criteria. They don't show up in the results if there are no financial records for them. Will I have to do separate queries for this, or is there any way to show people if they don't have records in the 2nd table?

 

[Pat Hartman]

Use a LEFT join to connect the main table to the transactions table. In QBE view, double click on the center of the join line and choose the option that returns all rows from the main table and matching rows from the transaction table.