help with "as"

From: Xiaowen Wang <swangken_at_cfdlab.ae.utexas.edu>
Date: 28 Feb 2001 12:34:40 -0600
Message-ID: <m2ofvmbqrj.fsf@speedo.happyhome.org>

Hi:
I tried some queries on the starter database coming with oracle 8.1.7 on linux. It seems strange to me that the rename operator "as" cannot work with range variable, nor with subquery. Here're two examples:

1)
select * from emp as E where E.deptno = 10; Here I have to remove the "as" to make it work.

2)
select EN.*, dept.dname from
(select emp.deptno, emp.ename from emp where emp.job = 'CLERK') as EN, dept where EN.deptno = dept.dept.no;

I used to work with Cloudscape3.6, and similar usage of "as" worked pretty well there. Is this usage conforming to SQL92 or was I using Clouscape's extension? Another strange(sort of) thing is that it seems oracle doesn't have any join keyword. Every join operation has to be written as operations on cartesian product.

Thanks very much in advance.

XW Received on Wed Feb 28 2001 - 12:34:40 CST