Dalilai RIGHT JOIN keyword SQL

Dalilai RIGHT JOIN keyword SQL

RIGHT JOIN فعل يرجع إلى كل الصفوف في الجدول (table_name2) حتى لو لم يكن هناك تطابق في الجدول (table_name1).

RIGHT JOIN فعل لفظ

SELECT column_name(s)
FROM table_name1
RIGHT JOIN table_name2
ON table_name1.column_name=table_name2.column_name

Rarrabawar:A cikin tabbata na mutum, RIGHT JOIN za ta'a zama RIGHT OUTER JOIN.

Tabbata na farko (ana iya amfani dashi a shirin shirin):

"Persons" tabbata:

Id_P LastName FirstName Address City
1 Adams John Oxford Street London
2 Bush George Fifth Avenue New York
3 Carter Thomas Changan Street Beijing

"Orders" tabbata:

Id_O OrderNo Id_P
1 77895 3
2 44678 3
3 22456 1
4 24562 1
5 34764 65

Tarihin Right Join

A yau, a rini a bai nuna dukuna na kwarin, kuma na kwarin su - idan su a cikin kwarin.

Za a iya samun SELECT a hanyar:

SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo
FROM Persons
RIGHT JOIN Orders
ON Persons.Id_P=Orders.Id_P
ORDER BY Persons.LastName

Gaskiya a nuna:

LastName FirstName OrderNo
Adams John 22456
Adams John 24562
Carter Thomas 77895
Carter Thomas 44678
　 　 34764

Rarrabawar RIGHT JOIN za ta'a zai kwanan na gaskiya (Orders) a zai kaiwai dukuna, kuma yana kaiwai da kwanan na gaskiya (Persons) a kaiwai dukuna.