[V4RB] Join problem

[Ruslan Zasukhin]

on 3/4/04 2:09 PM, Guillermo at guillermo at parsec.info wrote:

>>> 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

What you get instead?

Can you make small db with 3 tables to show me problem?


TIP: may be if you make 2 aliases to main_table,
This will help?


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------