jwebster77
asked on
return records even if rows are not contained in linked table
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
As an aside, to view some pretty pictures that will help you understand the different joins, go to images.google.com and search for 'SQL Join Types'. There's many good pictorals out there, and my grabbing one and posting it here would violate copyrights.
Hi jwebster77.
Do you need more help on this question? I think Jim's gave a very good answer but let us know if something still missing.
Do you need more help on this question? I think Jim's gave a very good answer but let us know if something still missing.
Can you post the query you're running that doesn't get all of the parents?
ASKER
Thank you to Jim! Great Advice, Great Link!