Re: SQL syntax question

On 1 Feb 2005 14:26:18 -0800, "Sean" <seanm555_at_comcast.net> wrote:

>I have a statement that works on SQL server and doesn't on Oracle (v9):
>
>select FLD1, FLD2 from (select distict FLD1, FLD2, FLD3 from TBL1) As X
>
>Oracle error #93: SQL command not properly ended.
>
>What's the problem with the statement that Oracle doesn't like?...

 What's the actual SQL you tried to run? "distict" isn't going to work.  And error 93 is not the one you posted; "SQL command not properly ended" is error 933 (ORA-00933).

The error likely refers to the 'AS' at the end - Oracle doesn't allow the AS keyword when aliasing table names.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_10002.htm#i2126863

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool