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

crosstab query child table count 5
Searching for parent in child-parent table 5
delete parent records where child fields are blank 2
Using Multiple Fields to Find Unmatched Records 5
Multi-table grouped query ungrouping - don't know why 4
select query of parent and child in one row 6
Query that references a field ID(P_K) to filter data from other ta 1
Parameter query to select multiple child records on the same field 2

Top