db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Guillaume Barré <Guillaume.Ba...@technomedia.ca>
Subject RE: sql translation
Date Wed, 17 Mar 2004 20:18:20 GMT
You can write your where condition like this

Criteria criteria = new Criteria();
criteria.addJoin(sys_contact_user.sys_contact_id, sys_contact.id);

And to get fields name,  firstname, lastname you may have generated method in bases classes.

Guillaume


-----Original Message-----
From: Sheng Guo [mailto:sheng@in.tum.de] 
Sent: March 17, 2004 3:03 PM
To: torque-user@db.apache.org
Subject: sql translation

Hello,

I am a new user of torque, and I would like to translate the following 
sql statement into torque,

select c.name, u.firstname, u.lastname
from   sys_contact c,  sys_contact_user u
where  u.sys_contact_id =  c.id

Could you please help me?

yours sincerely

Guo


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




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