db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Abou Zarr <matotour...@gmail.com>
Subject Complexe torque crieteria
Date Mon, 14 Mar 2005 12:06:28 GMT
Hi, how can i transform these query to torque
criteria?

sql = "select distinct salle "
       + "from tab1, tab2 where "
       + "((tab1.debut >= tab2 .debut "
       + "and tab1.debut < tab2 .fin) "
       + " or "
       + "(tab1.fin > tab2 .debut "
       + "and tab1.fin <= tab2 .fin)) "
       + "and tab2 .idsession = '" + session + "'";

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