[jboss-user] [EJB 3.0] - Re: EntityManager's Native Query & Paging Results
rabbiaqaswar
do-not-reply at jboss.com
Fri Jun 13 10:04:25 EDT 2008
Following is the sql query:
SELECT DISTINCT USR.USERID FROM USER USR, USERWATCH UW WHERE USR.ADDEDBYID =1 AND USR.COUNTRY = CASE WHEN (UW.COUNTRY is null) THEN USR.COUNTRY ELSE UW.COUNTRY END AND USR.ALIVE = 'A'
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4157968#4157968
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4157968
More information about the jboss-user
mailing list