Hi Varun, You can make EntityCondition using:
EntityCondition.makeCondition("USER_LOGIN_ID", EntityOperator.GREATER_THAN_EQUAL_TO, PARTY_ID) or EntityCondition.makeCondition("USER_LOGIN_ID", EntityOperator.LESS_THAN_EQUAL_TO, PARTY_ID) -- Thanks & Regards, Pankaj Savita Mob: +91 9890262476 Mail to: pankajsav...@gmail.com On Mon, Oct 11, 2010 at 4:40 PM, varun bhansaly <vbhans...@gmail.com> wrote: > Hi, > Is it possible to compare two columns using the entity engine, > For eg, write a query like this - > SELECT * FROM USER_LOGIN WHERE USER_LOGIN_ID <> PARTY_ID > > -- > Regards, > Varun Bhansaly >