COMPUTER SCIENCE AND ENGINEERING
SQL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
CROSS JOIN
|
|
|
FULL INNER JOIN
|
|
|
FULL OUTER JOIN
|
|
|
LEFT JOIN
|
Detailed explanation-1: -SQL LEFT OUTER JOIN includes in a result table unmatched rows from the table that is specified before the LEFT OUTER JOIN clause. SQL RIGHT OUTER JOIN creates a result table and includes into it all the records from the right table and only matching rows from the left table.
Detailed explanation-2: -The LEFT JOIN keyword returns all records from the left table (table1), and the matching records from the right table (table2). The result is 0 records from the right side, if there is no match.
Detailed explanation-3: -Four types of joins: left, right, inner, and outer. In general, you’ll only really need to use inner joins and left outer joins. Which join type you use depends on whether you want to include unmatched rows in your results: If you need unmatched rows in the primary table, use a left outer join.
Detailed explanation-4: -What is Left Join in SQL? Left Join is a keyword, which is used to select all rows from the left table and also the matched values between the two tables.