Query results showing table relationship

[Steven.Allman]

Yeah, had no idea how to title this thread.
I have two tables, we will call table1 and table2. Table1 shows administrative data for people who have had negative action against them. table2 is the administrative data regarding the corrective action taken by the individual.


I want to run a query to show who has NOT done any type of corrective action. However, it only shows the results if ANY information has been put into Tabel2.
I need to know if record345 has no information in table2, but he is not included in my query results.
How do i do this?

[orange]

Investigate Left join.

http://www.w3schools.com/sql/sql_join_left.asp

[RagJose]

Access' Query Wizard used to offer "Find records with no correspondent in another table" as one of the options. If your version has it, it should get you there...