Which of the following type of Join returns all rows from the left table even if no matches are found in the right table?

36. Which of the following type of Join returns all rows from the left table even if no matches are found in the right table?

  1. LEFT JOIN
  2. INNER JOIN
  3. RIGHT JOIN

Answer: A) LEFT JOIN

Explanation:

LEFT JOIN returns all rows from the left table even if no matches are found in the right table.

Comments and Discussions!

Load comments ↻






Copyright © 2024 www.includehelp.com. All rights reserved.