I see this conversation is going nowhere - thanks for the effort, but I'll try and solve this on my own. I 've done more complex sql than this in...

Christopher - thanks for the help.

I used the same query as in the beginning of this post.

all I need is one row with accumulative child values and not duplicate rows...

Christopher,

removing the webref had no effect - here is my output.

MultipleID Date Region Category Description Web Views Offers Made Broker Interest Auction...

Christopher,

I think in a nutshell what I'm asking is, why is GROUP BY not giving me unique result rows - I have tried GROUP BY, HAVING, UNION - nothing works,...

Christopher, basically all tables are joined on (Int) PKs and FKs and tbljMultipleAuctions is the Top parent table for which I want unique rows.

Please help as I need to...