Q. Which type of JOIN returns all records from the left table and the matched records from the right table?
Solution:
A LEFT JOIN (or LEFT OUTER JOIN) returns all rows from the left table (Table1), and the matched rows from the right table (Table2). If there is no match, the columns from the right table will have NULL values.
Related Questions
Q. Which query would count the number of distinct cities in the ‘Customers’ table?
View SolutionQ. What is the purpose of the HAVING clause?
View SolutionQ. How can you remove a table from the database?
View Solution
Get Question Bank
Strengthen Your Practice with our comprehensive question bank.
