Introduction SQL

Basic SQL

SQL Constraints

Advance SQL

SQL Joins

SQL Function

SQL FULL Outer Join - SQL FULL Join


SQL Full Join (Full Outer Join) always contains all records of left table (Table A) and right table (Table B) even of join condition does not find any matching record in both left or right table. Returned result contains set NULL value for all column that are lack of value in matching rows.

SQL FULL Join

Example Table

Considering following sql full join example, category, product is our example table.

SQL> SELECT * FROM category;
CATEGORY_IDCATEGORY_NAME
1Mobiles
2Laptops
3Laptops
4Cameras
5Gaming



SQL> SELECT * FROM product;
CATEGORY_IDPRODUCT_NAME
1Nokia
1Samsung
2HP
2Dell
3Apple
4Nikon
NullPlaystation

Run it...   »


Example Statement :

SQL> SELECT *
    FROM product FULL OUTER JOIN category
    ON product.category_id = category.category_id;

CATEGORY_ID PRODUCT_NAME              CATEGORY_ID CATEGORY_NAME
----------- ------------------------- ----------- -------------------------
          1 Samsung                             1 Mobiles
          1 Nokia                               1 Mobiles
          2 Dell                                2 Laptops
          2 HP                                  2 Laptops
          3 Apple                               3 Tablet
          4 Nikon                               4 Cameras
       NULL Playstation						 NULL NULL
       NULL NULL                                5 Gaming

8 rows selected.

Run it...   »