Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: trying to convert sql left outer join to oracle
select * from sys.dual as you_are_correct
You are correct. The AS keyword is not supported when aliasing a table, but is for columns. The above example works in access but not in Oracle, for example. Received on Fri Dec 20 2002 - 09:13:26 CST