db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cristian Zoicas <zoi...@medialab.sissa.it>
Subject How to create a join ?
Date Thu, 11 Dec 2003 12:48:34 GMT


Hello all

I've tried to figure out how to use the Criteria class in
order to obtain a statement like

SELECT
       *
FROM
       T1, T2, T3
WHERE
       ( T1.id_t1= T2.id_t1 AND T2.id_t3 = T3.id_t3 )
       OR
       ( T1.id_t3 = T3.id_t3 )

but I was not able to do it.
Does anybody has any solution ?

Thank you in advance
Cristian Zoicas



---------------------------------------------------------------------
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