Database

View All Threads First Prev Next

how to compare an operation in where expression In sql GREG_DORIANcod26-Nov-12 4:29 GREG_DORIANcod 26-Nov-12 4:29  hi everybody I need to do something like that: SQL 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 obviously it doesnt work!, but I'm looking for suggestions modified 26-Nov-12 10:42am. Re: how to compare an operation in where expression In sql s_magus26-Nov-12 5:20 s_magus 26-Nov-12 5:20  Something like this should do the trick. SQL 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 Re: how to compare an operation in where expression In sql Mycroft Holmes26-Nov-12 11:56 Mycroft Holmes 26-Nov-12 11:56  Add Group By ProductName, Field2 after the where clause Never underestimate the power of human stupidity RAH

Last Visit: 31-Dec-99 18:00     Last Update: 30-Apr-24 8:37 Refresh 1

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.