Hi all, the query

select count(*) from TABLE1 A LEFT OUTER JOIN TABLE2 b
on a.ID1 = b.ID2;

is the ANSI SQL standard for outer join - why do I get a
ERROR at line 1:
ORA-00933: SQL command not properly ended

Do I have to install any specific ANSI support for Oracle ?
(Like that for English query support on SQL Server)

I am using Oracle 8.1.6 on Solaris.

Thanks,
Shiva.

[Edited by rshivagami on 03-28-2002 at 11:49 AM]