| LEFT JOIN, RIGHT JOIN syntax in Oracle - Urgent!!!! [message #370912] |
Mon, 06 March 2000 08:00  |
Vijay
Messages: 116
Registered: September 1999
|
Senior Member |
|
|
Can I use this syntax for performing outer joins in ORACLE:
SELECT * from tblEmp LEFT JOIN tblDept ON
tblEmp.DeptId = tblDept.DeptId
instead of using
SELECT * from tblEmp, tblDept
WHERE tblEmp.DeptId = tblDept.DeptId +
We have used the LEFT JOIN syntax with SQL Server 7.0
and now we want to port our app to Oracle but using this syntax gives a syntax error in Oracle.
Can anyone tell me any modification of the LEFT JOIN syntax that will work with Oracle without having to
put the join condition in the WHERE clause.
thanks,
Vijay
|
|
|
|
| Re: LEFT JOIN, RIGHT JOIN syntax in Oracle - Urgent!!!! [message #370918 is a reply to message #370912] |
Tue, 07 March 2000 05:21  |
Atavur Rahaman S.A
Messages: 23
Registered: January 2000
|
Junior Member |
|
|
Hello,
Good Day!
I think this is the one that what you are looking for.....Sometimes it's difficult to get the answer without joining Master-Index Table and Driving Table. Pls. find the query enclosed and let me know whether it's working or not.......
SQL> SELECT e.Employee_Number,e.Employee_Name,e.Employee_Salary,e.Department_Number,e.Hiredate_of_Employee,d.Department_Number,d.Department_Name,d.Department_Location FROM Employee e,Department d WHERE d.Department_Number NOT IN(SELECT p.Department_Number FROM Department p WHERE p.Department_Number e.Department_Number)
Regards
Atavur Rahaman S.A
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
