OQL join query multiplies sums of columns instead of only summing
0
The OQl below is supposed to sum the values of Q1 and Q2 for each Executive, but instead sums and then multiplies the sums. For example: if SUM(P.Qty) = 14 and SUM(O.OIPQty) = 2, the query returns 28 for both Q1 and Q2 The two entities have an association. SELECT P.Executive E, SUM(P.Qty) Q1, SUM(O.OIPQty) Q2 FROM WeeklyReqReport.Open_Reqs P INNER JOIN WeeklyReqReport.Offers_in_Process O ON P.Executive = O.Executive WHERE P.Org_Unit LIKE '6%' GROUP BY P.Executive