db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Engelhardt, ITS BetrWi AE2, FD" <D.Engelhar...@deutschepost.de>
Subject AW: selecting from multiple tables
Date Fri, 23 May 2003 09:29:12 GMT
Try
	Criteria crit = new Criteria();
	crit.addJoin(EMPPEER.POSTID, POSTPEER.POSTID);
	crit.add(EMPPEER.EMPNO);
	... all of your columns
	List lst = BasePeer.doSelect(crit);

This example is just a pattern. Im not shute if you have to use BasePeer oder Peer but you
will find out.

Good look
Dieter


-----Urspr√ľngliche Nachricht-----
Von: Shin Ohkubo [mailto:sh.okubo@po1.iftc.co.jp]
Gesendet: Freitag, 23. Mai 2003 02:16
An: 'Turbine Torque Users List'
Betreff: selecting from multiple tables


Hello,
Can anyone show me how I can select from multiple database tables?

This is my sql:

"select emp.empno, emp.empname, post.postname from emp, post
 where emp.postid=post.postid"

And I want to obtain the result as a List object.
How do I represent the above sql? Is it possible to do this?

many thanks!

Shin O.


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