SQL Getting Started Tutorial: SQL Right JOIN right-hand

SQL Getting Started Tutorial: SQL Right JOIN right-hand

SQL Right JOIN keyword
The RIGHT join keyword returns all rows from the right table (table_name2), even if there are no matches in the left table (table_name1).

SQL syntax

SELECT column_name (s) from
table_name1 right
JOIN table_name2 on 
table_name1.column_name=table_ Name2.column_name

A: Some database join rights are called Right outer joins.

Correct SQL join for example
In the person table:

Address City

p_id	LastName	FirstName
1	Hansen	Ola	TIMOTEIVN 10	Sandnes
2	Svendson	Tove	BORGVN 23	Sandnes
3	Pettersen	Kari	STORGT 20	Stavanger

The "Orders" table:

o_id	OrderNo	p_id
1	77895	3
2	44678	3
3	22456	1
4	24562	1
5	34764	15

Now we want to list all the commands with the carrier-if any, from the above table.

We use the following SELECT statement:

SELECT Persons.lastname, Persons.firstname, Orders.orderno from Persons right JOIN Orders on persons.p_id =orders.p_id ORDER BY Persons.lastname

LastName	FirstName	OrderNo
Hansen	Ola	22456
Hansen	Ola	24562
Pettersen	Kari	77895
Pettersen	Kari	44678
		34764