w1coding.comAll tutorials

SQL Fulljoin

SQL lessons
  1. Environment Setup
  2. Introduction
  3. Select
  4. Where
  5. Decision
  6. Insert
  7. Delete
  8. Distinct
  9. Limit
  10. Operator
  11. In
  12. Join
  13. Leftjoin
  14. Rightjoin
  15. Fulljoin
  16. Groupby
  17. Having
  18. Order
  19. Update

SQL FULL OUTER JOIN

The FULL OUTER JOIN clause returns all rows when there is a match in one of the tables. It returns NULL on the side that does not have a match.

Example of FULL OUTER JOIN

SELECT Users.first_name, Users.last_name, Orders.order_date
FROM Users
FULL OUTER JOIN Orders ON Users.user_id = Orders.user_id;
    

This query retrieves all users and all orders, combining matching records from both sides and filling in NULL where there is no match.