Group By and Sum Issue

[romeogq]

Can anyone please tell me how I can get the ins_id's to group so that the dollar amounts sum up properly? My SQL and current out put is listed below.

[Dan_Bracuk]

Do inner joins instead of outer joins.

[cf_dev2]

If you want the results grouped by INS_ID, why are you grouping by i.ins_id and t.tic_rate?

[romeogq]

Thanks for the reply.

Dan,
I can't do all INNER JOINS because not all the instances have tickets, and not all the ticket records have purchase records.

cf_dev2,
The good ol' fashion 'aggregate function' error throws when tic_rate is not in the group by clause.

[cf_dev2 · Accepted solution]

Okay. Is this the correct formula?
sum(p.pur_quantity) * t.tic_rate

Would
sum(p.pur_quantity * t.tic_rate)

return the same/correct results?

[romeogq]

DEE-DE-DEEEE!!!

LMAO, Thanks that was it. Wow.