>Hallo,
>somewhere can tell me the right syntax for the follow SQL Statement in
ORACLE 7.3 (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



An easy way to get the syntax on a simple query like this is to use the view designer and copy the SQL statement into your code.