parent child link query



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,


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