Hi
Could any1 help me with this weird problem.
I am trying to make a query to compare to tables that are quite similar. This is for a shop. One table contains a ordered quantity, and the other table contains a delivered quantity. What i really want is to sum all the ordered quantities in table1 and compare it with sum delivered quantities in table2 for each order, and if sum table 1 is larger than sum table 2, print result. The trouble is that it seems like Mysql cant handle that i use sum for to tables in the same query. The sum results is completely wrong. However for test reasons i tried to sum only one of the tables, and then i get the rigt sum.
Hope this was understandable, and that one of you experts out there will help me with this problem.
Thanks alot.
Tom