Environment used – Following simple query is giving me an error : ORA-00933:SQL command not properly ended On SQL Developer 1.5.1 – Answer Oracle did not support the ANSI join syntax until version 9i. Also, Huy Ngo is correct that Oracle does not allow AS for table aliases. Try this code instead: