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