Hello-

I'm used to using MSSQL, but I'm now working on an Oracle system. I need to use a Left outter join for a query I'm writting, but I am getting a syntax error that I don't know how to fix. Please let me know if you see a blatant problem with this FROM clause.

FROM rss_user LEFT JOIN ent_user ON rss_user.user_id = ent_user.user_id

I get a "ORA-00933: SQL command not properly ended" error on the word JOIN.

Thanks in advance,
Mike

Mike-
It looks like we're both in the same boat. I've spent all weekend learning about Oracle and had the exact same question as I am trying to port code form SQL Server 2K to Oracle 8i/9i.
Instead of defining the join in the FROM clause, you comma delimit the tables and join them in the where clause to get a left join I think it looks like this (I'm new)
WHERE table1.field (+) = table2.field
You might need to move the (+).
HTH

yes, you can use some thing like this
field_name1 (+) = field_name2 or
field_name1 = field_name2 (+)