leftjoin

SQL LEFT JOIN

The LEFT JOIN clause returns all rows from the left table and matched rows from the right table. If no match is found, the result is NULL on the right side.



  Example of LEFT JOIN
  
    SELECT Users.first_name, Users.last_name, Orders.order_date
FROM Users
LEFT JOIN Orders ON Users.user_id = Orders.user_id;
    
  
  This query retrieves the first and last names of users, along with their order dates (if available), including users with no orders.