db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sperlich, Tino" <t.sperl...@hpc-hamburg.de>
Subject SQL->Criteria howto
Date Mon, 22 Nov 2004 10:40:18 GMT
Hi all,

I'd like to express this SQL in criteria syntax, but smth. is still missing:

SELECT VORAVIS.VAVI_ID, VORAVIS.SEQUENZ 
FROM VORAVIS 
WHERE VORAVIS.AUFT_ID=67537 AND 
VORAVIS.SEND_SEQUENZ 
IN 
( 
 SELECT MAX(va.SEND_SEQUENZ) 
 FROM VORAVIS va 
 WHERE va.AUFT_ID=VORAVIS.AUFT_ID AND va.SEQUENZ=VORAVIS.SEQUENZ
 ) 

My main problem is how to create the table alias "va" in the IN clause.
Using the criteria.addAlias() method gives me "FROM VORAVIS, VORAVIS va", i.e.
double table statements.
For the in clause I use an adjusted criteria class supporting the addIn(column, criteria)
operation, basically just writing "column IN query".

What am I missing?

Thanks,
Tino

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message