parent child link query
in [Queries]
|
From: inungh on 14 Apr 2010 12:29 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,
From: KARL DEWEY on 14 Apr 2010 14:00 Use a left join -- FROM Parent LEFT JOIN Child ON Parent.PrimayKeyField = Child.ForeignKeyField -- Build a little, test a little. "inungh" wrote: > 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, > . >
|
Pages: 1 Prev: Query Criteria issue Next: dynamically choose columns in query |