Re: Help New To DB

I'm not sure this is a correct translation ... but it is certainly valid SQL in Oracle.

SELECT *
FROM x, y
WHERE x.a = y.a
AND x.b = y.b
AND x.c = y.c;

Daniel Morgan

Adam Kingston wrote:

> I am self-studying with a relational DB book.
> Let's say:
> Table X has attribute A, B, C
> Table Y alsa has attribute A, B, C
> A,B,C are common attributes.
>
> The book teaches relational algebra and calculus but doesn't have much
> examples on Oracle's SQL.
>
> I would like to learn how to convert the following expression (for example)
> into SQL with Oracle DBMS.
>
> projectA(projectB(projectC(X union Y)))
>
> Thanks.
Received on Mon Feb 25 2002 - 11:09:31 CST