Re: Select statement in from clause

From: Proffesional newbie <mobieladres_at_hotmail.com>
Date: 18 Sep 2002 08:13:08 -0700
Message-ID: <46b4a824.0209180713.bda0a35@posting.google.com>

> We select from this view:
> SELECT
> *
> FROM foo
>
> Replace the view name with its select and you get:
> SELECT
> *
> FROM (SELECT * FROM table2 WHERE col1 < SYSDATE)
>
> There is very little difference between SQL 1 and SQL 2. In 2 we simply
> substituted the name of the view with the actual SELECT statement for that
> view. Which is exactly what the database engine does with SQL 1.

Thnx !

Can you give me an example why they did not use a view ? It is more plesant to read, in mine opinion, when u are using the view.

Thnx again

Dennis Received on Wed Sep 18 2002 - 10:13:08 CDT