In an SQL query of two tables,which SQL keyword indicates that we want data from all the rows of one table to be included in the result,even if the row does not correspond to any data in the other table?
A)LEFT JOIN
B)RIGHT JOIN
C)INCLUDE
D)Both A and B are correct

Question

Quizplus · Accepted Answer

LEFT JOIN and RIGHT JOIN are SQL keywords used to include all rows from one side of a table relationship, even if there are no corresponding matches in the other table. LEFT JOIN includes all rows from the left table, and RIGHT JOIN includes all rows from the right table.

In an SQL Query of Two Tables,which SQL Keyword Indicates