SQL FULL JOIN Keyword

SQL FULL JOIN Keyword

Idan kowacce koyan kaɗan cikin tabbatar, FULL JOIN ƙanamin fassara zai ƙaɗa ƙoƙarin.

FULL JOIN ƙanamin fassara

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

Kira:A cikin tabbata na dukkanin, FULL JOIN ake kira FULL OUTER JOIN.

Tabbata gaba daya (ana amfani da ita a shirin shirin shirin shirin):

Tabbata 'Persons':

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

Tabbata 'Orders':

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

Kashiya (FULL JOIN) shahararri

Yanzu, a bari da a nuna dukkan mutane, da haɗin su da dukkanin dindindin, da dukkanin mutane da su rarraba, kuma duk dindindin da su rarraba mutane.

Anfarin ka amfani da SELECT da yau:

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

Rana:

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

Kananan FULL JOIN ake samun gaba daya daga tabbata (Persons) da tabbata (Orders) kowace yanada. Idan kowace yanada a 'Persons' ba a samu da kowace a tabbata 'Orders', ko kuma idan kowace yanada a 'Orders' ba a samu da kowace a 'Persons', wadannan yanada kuma za a samu.