Link to home
Start Free TrialLog in
Avatar of jwebster77
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!
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
Can you post the query you're running that doesn't get all of the parents?
Avatar of jwebster77
jwebster77

ASKER

Thank you to Jim!  Great Advice, Great Link!