1.

What is the left outer join and the right outer join in SQL?

Answer»
  • LEFT outer JOIN: It returns an ENTIRE SET of records from the left table ALONG with the matched records from the right table.
  • Right outer join: It returns an entire set of records from the right table along with the matched records from the left table.


Discussion

No Comment Found

Related InterviewSolutions