[V4RB] Join problem

[Guillermo]

El 04/03/2004, a las 13:05, Guillermo 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

Sorry, I want to say that  I need one result for each row in main_table