db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From CHIU YEE WEAY <ywc...@paradigm.com.my>
Subject Re: How to create a join ?
Date Fri, 12 Dec 2003 01:16:19 GMT
Greetings all,

>From your experience and understanding, is the JOIN clause a standard that
is applicaable across the different RDBMS, like the basic SELECT, WHERE,
INSERT, UPDATE, DELETE SQL clauses ? Is there any RDBMS not supporting
the JOIN clause ?

Example :

select ...... from (t1 join t2 on t1.c1 = t2.c2) where ......

Thanks.

Chiu Yee Weay
Systems Engineer
Paradigm Systems Sdn Bhd

Quoting jroviram@notes.banesto.es:

> 
> >>
> >> Easy, isnt it????
> >>
> 
> >yep... you have terrorized me :)
> >thank you anyway.
> 
> Yep.. but its the only solution to do it, i think. Torque is a great
> tool
> but its very limited when youare using queries with joins.. you can
> use
> another tool, like ObjectelationalBridge (OJB) to do it more easy..
> 
> If youre using only one join, Torque (automatically) generates some
> methods
> that could help you:
> 
> you can join (directly) T1 -> T2 :)
> 
> for example
> class BaseT1Peer {
> ...
>       protected static List doSelectJoinT2( Criteria c ) {
> ...
> }
> 
> if you get the source code, you can find the way its implemented..
> 
> Buuuut you can not join (directly) T1 -> T2 -> T3 :(
> 
> The solution that I use its valid with all sort of joins. Buuutttt :(
> the
> main problem its that youve got an array with [ T1, T2, T3 ] instead of
> T1,
> so you cannot do:
> T1.getT2() or T2.getT3()... :(
> 
> >>
> >> Ive got a framework to do this very easy ;)
> >>
> 
> >Is it possible to know what framework you are talking about ?
> 
> Well.. ive created some classes to do this sort of tasks ease. But now
> its
> very limited..
> 
> 
> Sorry about my english.. :)
> 
> 
> Jose Luis Rovira Martin
> 
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
> 
> 
> [ Scanned by JARING E-Mail Virus Scanner ( http://www.jaring.my ) ]
> 



----------------------------------------------------------------
This e-mail has been sent via JARING webmail at http://www.jaring.my

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