wood burning stoves 2.0*
The moose likes JDBC and the fly likes Left outer join or Right outer join on Oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Left outer join or Right outer join on Oracle" Watch "Left outer join or Right outer join on Oracle" New topic
Author

Left outer join or Right outer join on Oracle

Tejas Jain
Ranch Hand

Joined: Mar 04, 2008
Posts: 119
I have two tables: employee and department. The employee table has a foreign key dep_id pointing to the primary key, dep_id, of the department table.

Outer Left Join: SELECT d.name, e.name FROM department d, employee e WHERE d.dep_id = e.dep_id (+);

Do I get a Outer Right Join by just switching the sides on equal sign (=) like following?
SELECT d.name, e.name FROM department d, employee e WHERE e.dep_id (+) = d.dep_id;

They are both valid SQL statements. I guess the result set should be the same. Correct?



"Knowing is not enough, you must apply... Willing is not enough, you must do."
--Bruce Lee
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

Yes, the two statements are identical.

Similarly with the ANSI syntax, a left join can always be expressed as a right join (and vice versa), simply by reversing the order of the tables.
 
 
subject: Left outer join or Right outer join on Oracle
 
Similar Threads
Doubt regarding joins in SQL...
are these join same
Cannot understand MySqlQuery Working.
Allowed ORDER BY fields question
Question for SCBCD aspirants (and gurus)...