db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jan Marten Visser <jan.marten.vis...@virgil.nl>
Subject retrieving values form different tables in a single join
Date Mon, 10 Mar 2003 16:51:45 GMT
Hi All,

I want to retreive values from different tables that I combine in a row.
Take as an example the following SQL:

SELECT order.orderNo, line.productName
FROM   order,
       line,
WHERE  order.id = line.id;

I have tried all kinds of things and constructions using the Criteria
class, but basically it was guessing since I was not able to find this
in the documentation. Does anyone know how to do this?

Cheers,

Jan Marten

PS Seems like a basic question so I tried the archives of this list, but
these are inaccesible and return errors.


Mime
View raw message