Chapter 5, Problem 21TD

Program Plan Intro

RIGHT JOIN:

• This type of join returns all the records (rows) from the right table and the matched records (rows) from the left table.
• When the fields of left table do not match with the right one, then the fields are filled with “NULL” values.

Syntax:

SELECT column_Name(s) FROM table_Name1 RIGHT JOIN table_Name2 ON table_Name1.column_Name = table_Name2.column_Name;

In the above syntax, the right table is “table_Name2” and the left table is “table_Name1”.

LEFT JOIN:

• This type of join returns all the records (rows) from the left table and the matched records (rows) from the right table.
• When the fields of right table do not match with the left one, then the fields are filled with “NULL” values.

Syntax:

SELECT column_Name(s) FROM table_Name1 RIGHT JOIN table_Name2 ON table_Name1.column_Name = table_Name2.column_Name;

In the above syntax, the left table is “table_Name1” and the right table is “table_Name2”.

ORDER BY Clause:

SQL contains “ORDER BY” clause in order to sort rows. The values get sorted in ascending as well as descending order. The keyword used to sort values in ascending order is “ASC” and for descending order is “DESC”. By default, it sorts values by ascending order.

Syntax:

SELECT column_Name1, column_Name2 FROM table_Name ORDER BY column_Name2;