The (+) sign goes on the deficient side of the outer join in the WHERE clause.

Oracle does not use the LEFT OUTER join so the first part of your
query would translate to:

FROM  persons a, functions b
WHERE b.id = a.function_Id(+)

>Hallo,
>somewhere can tell me the right syntax for the follow SQL Statement in
>ORACLE 7 (Inner JOIN -> (+) )
>
>
>SELECT a.*, b.function, c.department
>from persons a
>LEFT OUTER JOIN functions b
>ON b.ID =a.function_Id
>LEFT OUTER JOIN departments c
>ON c.ID =a.department_id
>
>
>TIA
>achim huber