I'm At A Loss With Aggregating

[Guest]

Hello,

I work at a credit union. I have six tables with our member's deposit and
loan information in it, (Shares, Certificates, etc.). I need to consolidate
these six tables into one row per member with the trailer count and the sum
of all certificates or loans say. The issue is that each member (Social) can
have multiple account numbers and within those account numbers have multiple
club trailers.

Now, I've already created a table with all possible trailers for our
members. The problem is I can't seem to get it so all of one social's
information is in one record. It breaks it off into as many records as there
are base account numbers say.
My query is doing just what I asked it though. I asked for the first of SSN
and group by Account. I'm having trouble logicin this out though.

Thanks,

 

[George Nicholson]

If "..each member (Social) can have multiple account numbers..", don't you
want to group by (Social), *not* by Account, to get "..one row per member
(Social).." ?