File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes outer joins in DB2 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "outer joins in DB2" Watch "outer joins in DB2" New topic

outer joins in DB2

Ranch Hand

Joined: Nov 22, 2008
Posts: 18944
emp left join dept on dept.d_id = emp.case_id
left join emps on emps.d_id = emp.d_id

Does the above mean
emp left join dept
emp left join emps

am I right?
I agree. Here's the link:
subject: outer joins in DB2
It's not a secret anymore!