Re: How can I do it in SQL?
From: Dave Mausner <dmausner_at_brauntech.com>
Date: Sat, 24 Sep 1994 04:24:37 GMT
Message-ID: <1994Sep24.042437.21689_at_nntpxfer.psi.com>
Try the above modification.
Date: Sat, 24 Sep 1994 04:24:37 GMT
Message-ID: <1994Sep24.042437.21689_at_nntpxfer.psi.com>
In article <780325833466282_at_arcom.spb.su>, Anton V. Gruza <ant_at_geol.spb.su> says:
> I want to made outer join, such that I can see all people living at home 1,
>with check - if this person is in friendship with Alex.
>
> I try:
> SELECT PEOPLE.ID, PEOPLE.NAME, FRIENDSHIP_BETWEEN.ID_FROM
> FROM PEOPLE, FRIENDSHIP_BETWEEN
> WHERE PEOPLE.HOME = 1 AND PEOPLE.ID = FRIENDSHIP_BETWEEN.ID_FROM(+) AND
> FRIENDSHIP_BETWEEN.ID_TO(+) = 4;
^^^
Try the above modification.
-- Dave Mausner, Senior Consultant, Braun Technology Group, Chicago.Received on Sat Sep 24 1994 - 06:24:37 CEST