pulling a report from 3 tables

i am very new to access and need help pulling info from 3 tables, all three
tables have- id, last name, first name and DOB
i would like the report to end up like this
dismiss all records that have matching rows on all 3 tables
list all records that have no matches
mark the records from table1 that match either table2 or table 3

best case scenerio...
last name first name DOB table 2
table3
smith john 1-1-2001 true
smith jane 2-2-2002
true
smith fred 3-3-2003

where john was in table2 not table 3
where jane was in table3 not in table2
where fred was only in table1

thanks so much for any help
joewy


.