Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

outer joins in DB2

 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
and
emp left join emps

am I right?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic