El 03/03/2004, a las 20:51, Ruslan Zasukhin escribió: > Hi Guillermo, > > Yes, looks to be wrong result. > > Try please LEFT OUTER join > > > select * from main_table, table1, table2 > where > main_table.ptr_table1 *= table1.recID > and > main_table.ptr_table2 *= tabl2.recID Don't work, I need one result for each row in table1