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
	Criteria crit = new Criteria();
	... 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

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

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

View raw message