I have the two tables:
tblFamilys lists last names of various families (key is FamID)
tblIndividuals lists first names of individuals linked to their last name (in tblfamilys) through FamID
Some FamIDs have two people in tblIndividuals (a married couple) and some only have one (a single person). I need to create a list of each family, i.e.:
John and Jane Doe
Richard Smith
Sam and Deanna Casper
I had previously done this by creating a query of married people (with two tblIndividuals - thereby eliminating single people), then another query of individuals (by listing people that are not in the query of married people) and then unioning those two queries together.
What I am wondering is if there is a way to do this in one query (SQL statement) - what the SQL would be.
Any help would be greatly appreciated.
tblFamilys lists last names of various families (key is FamID)
tblIndividuals lists first names of individuals linked to their last name (in tblfamilys) through FamID
Some FamIDs have two people in tblIndividuals (a married couple) and some only have one (a single person). I need to create a list of each family, i.e.:
John and Jane Doe
Richard Smith
Sam and Deanna Casper
I had previously done this by creating a query of married people (with two tblIndividuals - thereby eliminating single people), then another query of individuals (by listing people that are not in the query of married people) and then unioning those two queries together.
What I am wondering is if there is a way to do this in one query (SQL statement) - what the SQL would be.
Any help would be greatly appreciated.