db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Howard Lin" <Howard....@vonage.com>
Subject RE: retrieving values form different tables in a single join
Date Mon, 10 Mar 2003 19:33:16 GMT
Did you try this http://db.apache.org/torque/criteria-howto.html ?

Howard Lin

> -----Original Message-----
> From: Jan Marten Visser [mailto:jan.marten.visser@virgil.nl]
> Sent: Monday, March 10, 2003 11:52 AM
> To: torque
> Subject: retrieving values form different tables in a single join
> 
> 
> 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.
> 
> 
> ---------------------------------------------------------------------
> 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