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,
firmapost@statnett.no
_________________________________________________________________
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org
|