[V4RB] Join problem

[Ruslan Zasukhin]

on 3/3/04 9:28 PM, Guillermo at guillermo at parsec.info wrote:

> Hello  I have problems to join three baseObjects, there are one main
> base objects with pointers to two baseObjects
> 
> select * from main_table, table1, table2
> where table1.recID =* main_table.ptr_table1 and tabl2.recID =*
> main_table.ptr_table2;
> 
> I think that the cursor must return all records of the main_table but
> only returns the records where there are a pointer with table3
> 
> If I use only one join all works fine, for example:
> 
> select * from main_table, table1 where table1.recID =*
> main_table.ptr_table1
> 
> or
> 
> select * from main_table, table2 where table2.recID =*
> main_table.ptr_table2
> 
> I tried to use parenthesis without success.

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


Also do not use ; at the end.
1.x can be confused.


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