Left outer join

[Ruslan Zasukhin]

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

> Hi I am trying to do a left outer join but get error 602 (Table not found)
> 
> I tried these syntaxes:
> 
> SELECT name,CRD_Number FROM KUNDENtable LEFT OUTER JOIN KUNDENKARTENtable
> WHERE KD_ID = 1 AND CRD_KD_ID = KD_ID
> 
> And
> 
> SELECT name,CRD_Number FROM KUNDENtable|A LEFT OUTER JOIN
> KUNDENKARTENtable|B WHERE A.KD_ID = 1 AND B.CRD_KD_ID = A.KD_ID
> 
> What is wrong?

Please look into ValentinaSQL.pdf

We use syntax of SQL Server

    WHERE id *= ptr

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