>select CodeField, ; > SUM( SumForFieldTotal ) as SumForFieldTotal, ; > SUM( SumForFieldQuant) as SumForFieldQuant, ; > Field3 ; > from ( ; > ; >>SELECT Table1.cod as CodeField, ; >> SUM( Table1.total) as SumForFieldTotal, ; >> SUM( Table1.quant) as SumForFieldQuant, ; >> Field3 ; >>FROM Table1 ; >>JOIN table3 ; >>ON Table1.cod = table3.code ; >>where table3.field4 = 1 ; >>GROUP BY Field3, CodeField ; >>UNION ALL select ; >> table2.cod as CodeField, ; >> sum( table2.total) as SumForFieldTotal, ; >> sum( table2.quant) as SumForFieldQuant, ; >> Field3 ; >> FROM table2 ; >> JOIN table3 ; >> ON table2.cod = table3.code ; >> WHERE table3.field4 = 1 ; >> GROUP BY Field3, CodeField ; >>ORDER BY CodeField ; > ; > ) as xxx ; >GROUP BY Field3, CodeField ; >ORDER BY CodeField > >>>
>>SELECT Table1.cod as CodeField, ; >> SUM( Table1.total) as SumForFieldTotal, ; >> SUM( Table1.quant) as SumForFieldQuant, ; >> Field3 ; >>FROM Table1 ; >>JOIN table3 ; >>ON Table1.cod = table3.code ; >>where table3.field4 = 1 ; >>GROUP BY Field3, CodeField ; >>UNION ALL select ; >> table2.cod as CodeField, ; >> sum( table2.total) as SumForFieldTotal, ; >> sum( table2.quant) as SumForFieldQuant, ; >> Field3 ; >> FROM table2 ; >> JOIN table3 ; >> ON table2.cod = table3.code ; >> WHERE table3.field4 = 1 ; >> GROUP BY Field3, CodeField ; >>ORDER BY CodeField >>>>