> SELECT ..., SUM(o.quantity)*o.price You've got an aggregate function in there, but no GROUP BY. So it's using all the rows as your group, and treating the rest of the columns are bare columns, which it's taking from one of the rows "at random" (not actually random, but that's another discussion) You need to either group by something for which you want info on the groups... or get rid of the aggregate functions.