Hi, I am thinking this is a pretty easy question.
I have a table called tblparents
I have a table called tblchildren
The field that links tblparents to tblchildren is household.
I need to return all of the records in tblparents even if no children exist in tblchildren. Right now when I run the query I only get results in tblparents where rows exist in tblchildren.
Help is greatly appreciated!