SQL Joins for Beginners | Full Outer Join Explained in Detail for Beginners using SQL Server 2022
In this video, I have explained the use of Full Outer Join via an example along with execution of Full Outer Join on SQL Server.
Right Outer Join Video : • SQL Joins for Beginners | Right Outer Join...
Left Outer Join Video : • SQL Joins for Beginners | Left Outer Join ...
Chapters:
0:00 Explanation for Full Outer Join
2:01 Syntax and Example for Full Outer Join
2:31 LIVE Execution of Full Outer Join in SQL Server
For SQL Server Installation, Please watch this video : • How to Install SQL Server 2022 Database in...
For SQL Server Management Studio (SSMS) Installation and usage, please refer this video : • How to Install SQL Server Management Studi...
For SQL Server Database Creation, Please refer this video : • How to Create a New Database in SQL Server...
SQL Statements used in this video as under :
DROP TABLE SUPPLIER_A
DROP TABLE SUPPLIER_B
CREATE TABLE SUPPLIER_A
(
PRODUCT_ID VARCHAR(5),
PRODUCT_NAME VARCHAR(25),
PRODUCT_QUANTITY NUMERIC(3) NOT NULL,
PRODUCT_PRICE NUMERIC(5,2) NOT NULL,
PRODUCT_COUNTRY VARCHAR(20) NOT NULL
CONSTRAINT PK_SUPP_1 PRIMARY KEY(PRODUCT_ID)
)
CREATE TABLE SUPPLIER_B
(
PRODUCT_ID VARCHAR(5),
PRODUCT_NAME VARCHAR(25),
PRODUCT_QUANTITY NUMERIC(3) NOT NULL,
PRODUCT_PRICE NUMERIC(5,2) NOT NULL,
PRODUCT_COUNTRY VARCHAR(20) NOT NULL
CONSTRAINT PK_SUPP_2 PRIMARY KEY(PRODUCT_ID)
)
INSERT INTO SUPPLIER_A VALUES ('10011','ORANGE',50,45,'SPAIN')
INSERT INTO SUPPLIER_A VALUES ('10012','PINEAPPLE',10,25,'SOUTH AFRICA')
INSERT INTO SUPPLIER_A VALUES ('10015','APPLE',20,50.50,'INDIA')
INSERT INTO SUPPLIER_A VALUES ('10016','MANGO',20,80,'INDIA')
INSERT INTO SUPPLIER_A VALUES ('10017','BANANA',20,30,'ECUADOR')
INSERT INTO SUPPLIER_A VALUES ('10018','WATERMELON',30,20,'BRAZIL')
INSERT INTO SUPPLIER_A VALUES ('10020','GUAVA',30,20,'NETHERLANDS')
INSERT INTO SUPPLIER_A VALUES ('10021','STRAWBERRY',20,40,'SPAIN')
select * from SUPPLIER_A
INSERT INTO SUPPLIER_B VALUES ('10011','ORANGE',20,50,'SOUTH AFRICA')
INSERT INTO SUPPLIER_B VALUES ('10012','PINEAPPLE',12,23,'SOUTH AFRICA')
INSERT INTO SUPPLIER_B VALUES ('10013','GRAPES',15,30.50,'INDIA')
INSERT INTO SUPPLIER_B VALUES ('10014','PAPAYA',10,60,'INDIA')
INSERT INTO SUPPLIER_B VALUES ('10017','BANANA',20,30,'INDIA')
INSERT INTO SUPPLIER_B VALUES ('10019','KIWI',15,85,'CHINA')
INSERT INTO SUPPLIER_B VALUES ('10020','GUAVA',20,25,'NETHERLANDS')
select * from SUPPLIER_B
select * from SUPPLIER_A
/* FULL OUTER JOIN */
SELECT A.PRODUCT_ID, A.PRODUCT_NAME, B.PRODUCT_ID, B.PRODUCT_NAME
FROM SUPPLIER_A A
FULL OUTER JOIN SUPPLIER_B B ON A.PRODUCT_ID = B.PRODUCT_ID
