select x.ProductName, sum(x.field1+y.field2) as Mysum, y.field2 from tablexxx as x inner join tableyyy as y on x.id =y.id where as Mysum - y.field2 > 0
Select ProductName, MySum, field2
From (Select x.ProductName, SUM(x.field1 + y.field2) as MySum, y.field2
From tablexxx as x inner join
tableyyy as y on x.id = y.id) as q
Where MySum - field2 > 0
General News Suggestion Question Bug Answer Joke Praise Rant Admin
Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.