Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inner join
Message
From
07/12/2001 06:37:26
 
 
To
All
General information
Forum:
Oracle
Category:
PL/SQL
Title:
Inner join
Miscellaneous
Thread ID:
00591045
Message ID:
00591045
Views:
57
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


TIA
achim huber
Next
Reply
Map
View

Click here to load this message in the networking platform