Hi I need a query something like the one following using crietria obj.
SELECT RULE.RULE_SEQ, RULE.RULE_ID, RULE.RULE_NAME, RULE.RULE_DESC, RULE.TERMS_USED, RULE.FACTS_USED, RULE.RULE_GROUP_ID, RULE.STATUS_ID, RULE.USER_ID_CREATED, RULE.DATE_CREATED, RULE.USER_ID_UPDATED, RULE.DATE_UPDATED, RULE.RULE_GROUP_SEQ, UPPER(RULE.RULE_GROUP_ID) FROM RULE, RULE_APP_MAP
WHERE RULE_APP_MAP.APP_SEQ=1000
AND (RULE.RULE_NAME LIKE '%Ano%'
OR RULE.RULE_ID LIKE '%101%' )
AND RULE_APP_MAP.RULE_SEQ=RULE.RULE_SEQ
ORDER BY UPPER(RULE.RULE_GROUP_ID) ASC
I am not getting any idea how to do that. Can any body help me
Thanks Sudhakar Dandamudi
_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
