how to use complex queries in java method

[Mathius Allo]

Just wondering if someone can provide guidance on where I can find useful information on how to model a more complex queries in OFBiz from java method i.e.

SELECT b.* FROM SECURITY_GROUP_PERMISSION a, SECURITY_PERMISSION b where a.PERMISSION_ID = b.PERMISSION_ID and a.GROUP_ID = 'BIZADMIN'

or

select a.* from SECURITY_PERMISSION a where a.PERMISSION_ID not in (select b.PERMISSION_ID from SECURITY_PERMISSION b, SECURITY_GROUP_PERMISSION c where b.PERMISSION_ID = c.PERMISSION_ID and c.GROUP_ID = 'FULLADMIN')
 

Thanks in advanced.
Mathius


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com