Try
SELECT pt.*, ct.b_Name ;
FROM ParentTable pt ;
JOIN ChildTable ct ;
ON pt.a_pk = ct.b_afk ;
AND b_area = (SELECT MAX(b_area) FROM ChildTable ct2 WHERE ct2.b_pk = ct.b_pk)
>
>I'm hoping to get some assistance on a specific SQL query. Here's a simplified version of the two tables it is working off:
>
>Table A (parent)
>a_pk (pk)
>
>Table B (child)
>b_pk (pk)
>b_afk (fk to parent)
>b_area (area)
>b_name (non-unique name)
>
>Problem: I am trying to write a query that returns the name (b_name) of the largest child (b_area) for all parent records.
>
--sb--