FULL JOIN

SQL FULL OUTER JOIN Kalit So'zi

FULL OUTER JOIN kalit so'zi chap (table1) yoki o'ng (table2) jadval yozuvlari orasida moslik bo'lganda barcha yozuvlarni qaytaradi.

FULL OUTER JOIN Sintaksisi

SELECT column_name(s)
FROM table1
FULL OUTER JOIN table2
ON table1.column_name = table2.column_name
WHERE condition;

Demo Ma'lumotlar Bazasi

Ushbu o'quv qo'llanmada biz mashhur Northwind namunaviy ma'lumotlar bazasidan foydalanamiz.

Quyida "Customers" jadvalidan bir tanlov:

Va "Orders" jadvalidan bir tanlov:

SQL FULL OUTER JOIN Misoli

Quyidagi SQL bayonoti barcha mijozlarni va barcha buyurtmalarni tanlaydi:

SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
FULL OUTER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
ORDER BY Customers.CustomerName;

Natijalar to'plamidan bir tanlov quyidagicha ko'rinishi mumkin: