w1coding.comAll tutorials

SQL Join

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 JOIN (INNER JOIN)

The INNER JOIN clause combines rows from two or more tables based on a related column between them.

Example of INNER JOIN

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

This query retrieves the first and last names of users, along with their order dates, by joining the "Users" and "Orders" tables based on the user ID.