Page 96 - CITS - Computer Software Application -TT
P. 96
COMPUTER SOFTWARE APPLICATION - CITS
Syntax
SELECT columns
FROM table1
LEFT JOIN table2 ON table1.column = table2.column;
3 RIGHT JOIN (RIGHT OUTER JOIN)
• Returns all rows from the right table and the matched rows from the left table.
• If there is no match in the left table, NULL values are included for the columns from the left table
Syntax
SELECT columns
FROM table1
RIGHT JOIN table2 ON table1.column = table2.column;
4 FULL JOIN (FULL OUTER JOIN)
• Returns all rows when there is a match in either the left or the right table.
• If there is no match in one of the tables, NULL values are included for the columns from the table without a
match.
83
CITS : IT&ITES - Computer software application - Lesson 18 - 36
