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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
