Hello all,

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.

Any help is most appreciated!