hello list, is there a convenient way to do the following with Criteria: select distinct document_id from channel_document_latest where channel_id=26942 and document_id not in (select document_id from channel_document_latest where channel_id = 26945 or channel_id = 26944)
or would the easiest way be to use BasePeer.executeQuery(sql)? cheers, pj Statnett SF, Tel. head office +47 22527000, Enterprise No. NO 962 986 633 VAT, www.statnett.no, [EMAIL PROTECTED] _________________________________________________________________ This e-mail and any attached files are confidential and may be legally privileged. If you have received this transmission in error please notify the sender by reply e-mail immediately and then delete the e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete. If verification is required please request a hard copy version. This e-mail message has been virus checked by the virus programs used by Statnett SF. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
