Easy Query?

hyperfoo · **Joined:** Wed Oct 31, 2007 6:17 am **Posts:** 2

Hi list,

I need to realize the following query using criterias and expressions:

SELECT columnA, intColumnB, intColumnC, intColumnD FROM table1 WHERE inColumnB>(intColumnC+intColumnD).

Right now I have no ideai how to do the WHERE CLAUSE. Does anybody have a hint how to do this?

regards,

hyperfoo

LaLiLuna · **Posted:** Sat Nov 03, 2007 4:15 pm

just a guess withoug having tried

select c.c1, c.c2, c.c3 from MyObject c where c.c1 > (c.c2+c.c3)