db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cristian Zoicas <zoi...@medialab.sissa.it>
Subject Re: How to create a join ?
Date Fri, 12 Dec 2003 08:49:03 GMT


On Fri, 12 Dec 2003, CHIU YEE WEAY wrote:

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

I really cannot answer that question. All of the RDBMS systems I used
support the syntax you nominated.

However I do not see the connection between your answer and my question
to this mailinglist.

Cristian Zoicas

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


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