Derived table in release 4.0.x?
I am working with release 4.0.16-nt. I have tried to use a derived table with no success.
select tmp.id, tmp.code
from ( select id, code from film ) as tmp
I get error 1064, error in SQL syntax.
Are derived tables supported in release 4.0.x or do I need to upgrade to 4.1?
Thanks.
-jb
Subject
Written By
Posted
Derived table in release 4.0.x?
August 17, 2004 01:40PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.