parent child link query

I

inungh

I have a query which has a parent and child link tables and would like
to have all the records in the parent even no child for this parent.

It seems MS Access gives the link only the parent has child.
I try to use outer join, but MS Access gives me it contains ambiguous
outer joins.

Any information is great appreciated,
 
K

KARL DEWEY

Use a left join --
FROM Parent LEFT JOIN Child ON Parent.PrimayKeyField = Child.ForeignKeyField
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Child Timelines to Multiple Parents 0
crosstab query child table count 5
delete parent records where child fields are blank 2
Searching for parent in child-parent table 5
Separating Parent and Child Fields 7
Making a query to get data from a parent-child table 1
Multi-table grouped query ungrouping - don't know why 5
Using Multiple Fields to Find Unmatched Records 5

Top