Re: SQL question

From: Tom Vanstraelen <straelet_at_my-deja.com>
Date: Fri, 22 Sep 2000 15:17:37 GMT
Message-ID: <8qft5p$1nn$1@nnrp1.deja.com>

Hi,

A possible solution is :

SELECT tmp.id, tmp.zdata, tmp.xdata, ydata FROM y, (SELECT z.id, zdata, xdata FROM z,x WHERE z.id = x.id (+)) tmp WHERE tmp.id = y.id (+)

SQL> / ID ZDATA XDATA YDATA
--------- --------- --------- ---------

        1         1         1
        2         2         2         2
        3         3                   3

HTH, Tom Vanstraelen

> Hallo
>
> I have three tables
>
> First table (Z)
>
> ID ZDATA
> ---- ----
> 1 Z1
> 2 Z2
> 3 Z3
> 4 Z4
> 5 Z5
>
> Second table (X)
>
> ID XDATA
> --- ----
> 1 X1
> 2 X2
>
> Third table (Y)
>
> ID YDATA
> --- ---
> 2 Y2
> 3 Y3
>
> and I want a query whose result should be
>
> ID ZDATA XDATA YDATA
> --- ----- ---- -----
> 1 Z1 X1
> 2 Z2 X2 Y2
> 3 Z3 Y3
>
> Can anybody help me write this query?
>
> Thank you
> Diego Amicabile

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 22 2000 - 10:17:37 CDT