How to Combine Table Rows Using SQL JOIN

SQL Joins: Main Tips

• SQL joins are used to combine more than one tables rows.
• SQL INNER JOIN is the most common JOIN. An SQL INNER JOIN returns all multiple tables rows where the join condition is met.

SQL Join: Types

• LEFT JOIN: It returns the left table rows and right table rows which matched.
• RIGHT JOIN: It returns the right table rows, and left table rows which matched.
• INNER JOIN: It returns all rows when there is the same record in BOTH tables.
• FULL OUTER JOIN: It returns all rows when the same record occurs in BOTH tables.

Pros

• Easy to use with a learn-by-doing approach
• Offers quality content
• Gamified in-browser coding experience
• The price matches the quality
• Suitable for learners ranging from beginner to advanced

Main Features

• Free certificates of completion
• Focused on data science skills
• Flexible learning timetable

GET 50% OFF

Pros

• Simplistic design (no unnecessary information)
• High-quality courses (even the free ones)
• Variety of features

Main Features

• Nanodegree programs
• Suitable for enterprises
• Paid Certificates of completion

UP TO 70% OFF

Pros

• A wide range of learning programs
• University-level courses
• Easy to navigate
• Verified certificates
• Free learning track available

Main Features

• University-level courses
• Suitable for enterprises
• Verified certificates of completion

FREE COURSES

Demo Database

This is a demo example from the "Orders" table in the database:

This is a demo example from the "Developers" table in the database:

INNER JOIN: Example

SELECT Customer_orders.ID, Developers.Name
FROM Customer_orders
INNER JOIN Developers ON Customer_orders.employee_id = Developers.ID;

The result table looks like this: