Query for parents with children only 1

[klange]

I need to write an SQL statement for ACCESS for a database with two tables with a one to many relationship I need a query that returns only parent records that have children and return the parent record only once, not once for each child. My query keeps returning the parent once for each child.

 

[cmmrfrds]

You should be able to do that with a subquery in the where clause. The subquery would group on the key that joins the 2 tables.

select id, fld1, fld2, etc from parenttable
where id IN
(select id from childtable group by id)

 

[klange]

Thanks ! That did the trick.