This content has been marked as final. Show 5 replies
Do inner joins instead of outer joins.
If you want the results grouped by INS_ID, why are you grouping by i.ins_id and t.tic_rate?
Thanks for the reply.
I can't do all INNER JOINS because not all the instances have tickets, and not all the ticket records have purchase records.
The good ol' fashion 'aggregate function' error throws when tic_rate is not in the group by clause.
Okay. Is this the correct formula?
sum(p.pur_quantity) * t.tic_rate
sum(p.pur_quantity * t.tic_rate)
return the same/correct results?
LMAO, Thanks that was it. Wow.