AW: Left outer join

[Ruslan Zasukhin]

on 10/2/03 6:31 PM, Florian Bogeschdorfer at fb at memedia.de wrote:

>> Please look into ValentinaSQL.pdf
>> 
>> We use syntax of SQL Server
>> 
>>     WHERE id *= ptr
>> 
> I did Ruslan. As I always do at least 20 minutes BEFORE I ask. Unfortunately
> I can not even find whether LEFT OUTER JOIN is supported at all. It is not
> even in the text of the pdf.

Florian, on page 10 of VSQL.pdf you can find paragraph

    OUTER JOIN.

> Also I am quite new to SQL.


> I also found out that this is the right syntax for alias
> SELECT * FROM KUNDENtable A, KUNDENKARTENtable B WHERE A.KD_ID=1 AND
> B.CRD_KD_ID=A.KD_ID

Yes.

> This works well but gets me a result only when the B.CRD_KD_ID=A.KD_ID finds
> a record in table B ( I habe been using this before without the Aliasses).
> What I want is all A records no matter if an eqivalent B record exists, but
> if it does then with ist fields.
> 
> But as soon as I put LEFT OUTER JOIN in it, I get 602
> 
> Sorry for asking,
> 
> Maybe someone else on the list could tell me how a left outer join is done.

In Valentina 1.x you need do

 SELECT * 
 FROM KUNDENtable A, KUNDENKARTENtable B
 WHERE 
    B.CRD_KD_ID =* A.KD_ID
   AND  
    A.KD_ID=1 


Note operator   =*



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