db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <Fisc...@seitenbau.net>
Subject RE: Join or Where Clause
Date Tue, 07 Dec 2004 10:24:32 GMT





Hi,

good hack, though it only works in oracle (as far as I know)

    Thomas

a.wahhabi@free.fr schrieb am 07.12.2004 11:16:14:

> Hi all
>
> About outer join, i use a simple join and i add '(+)' :
>
> criteria.addJoin(TableMasterPeer.ID, TableSlavePeer.ID + "(+)");
>
> and it return the good information
>
> Karim
>
>
> Selon Thomas Fischer <Fischer@seitenbau.net>:
>
> >
> >
> >
> >
> >
> > Hi Daniel,
> >
> > I have looked through the source code and it seems that your query
cannot
> > be generated generically with torque. The problem is that Torque does
not
> > support join conditions other than equal (=).
> > My suggestion for a quick solution would be to use any of the methods
> > BasePeer.ExecuteQuery() and create the SQL statement "by hand".
> >
> > Yous sql statement is fine, no need to use right joins.
> >
> >    Thomas
> >
> > "Daniel M├╝ller" <daniel0815@gmx.de> schrieb am 06.12.2004 08:35:01:
> >
> > > Hello,
> > >
> > > I have 2 tables. In one table stand numbers in the secound table
stand
> > > adresses. The have a foreign key
> > >
> > > NumberTable
> > > N_ID
> > > N_Number
> > >
> > > AdressesTable
> > > A_ID
> > > A_N_ID
> > > A_Name
> > >
> > > The adresses table have the foreign key A_N_ID=N_ID.
> > >
> > > In the number table stand very much numbers. Now i wont to find out
what
> > > numbers in the number table are free, without a relation. I wont to
build
> > a
> > > 1:1 relation. For this I need to know what number is not set for a
> > adress. I
> > > have made this statement:
> > >
> > >
> > > SELECT DISTINCT
> > > NumberTable.N_ID,
> > > NumberTable.N_NUMMER,
> > > FROM
> > > NumberTable,
> > > AdressesTable
> > > WHERE
> > > AdressesTable.A_N_ID<>NumberTable.N_ID;
> > >
> > > This statement works, but how i can create it with torque?
> > >
> > > Or is it better if I do it with right joins?
> > >
> > > How I do it with joins?
> > >
> > > Thanks for help.
> > >
> > > Daniel
> > >
> > > --
> > > NEU +++ DSL Komplett von GMX +++ http://www.gmx.net/de/go/dsl
> > > GMX DSL-Netzanschluss + Tarif zum superg├╝nstigen Komplett-Preis!
> > >
> > > ---------------------------------------------------------------------
> > > 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
> >
> >
>
>
>
> ---------------------------------------------------------------------
> 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