Subash
What is the difference between left outer join and right outer join?
By Subash in SQL Server on Jul 14 2016
  • Abhinav Abhishek
    Mar, 2017 17

    LEFT OUTER JOIN / LEFT JOIN returns all of the rows from LEFT table and the corresponding matching rows from the right table. RIGHT OUTER JOIN / RIGHT JOIN returns all the rows from the RIGHT table and the corresponding matching rows from the left table. If table does not have matching record then NULL value assigned for that column.

    • 2


Most Popular Job Functions


MOST LIKED QUESTIONS