SQL question

[Ruslan Zasukhin]

On 11/3/06 9:47 AM, "Florian Bogeschdorfer" <fb at memedia.de> wrote:

Hi Florian,

> Hi all!
> 
> Still a SQL intermediate, I need a pro answer! :-)
> 
> I have two tables, KUNDEN and KARTEN. It is a 1:M relation between the
> tables, so KUNDEN may have several KARTEN or none at all. Now I need a query
> that has all KUNDEN as a result with their first KARTE or all KARTEN but
> also if they have no link to KARTEN.

I think you ask about OUTER JOIN.

In v1 syntax is:

    WHERE KUNDEN.id *= KARTEN.ptr
 
> So "SELECT * FROM KUNDEN,KARTEN WHERE KUNDEN_ID=KARTEN_ID does not work, I
> don't get those without a link to KARTEN.
> 
> How can this be solved with V1 compatible SQL?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]