sql join multiple tables

Today, We want to share with you sql join multiple tables.In this post we will show you SQL INNER JOIN – Joining Two or More Tables, hear for SQL Inner-join with 3 tables we will give you demo and example for implement.In this post, we will learn about How to join three tables in SQL query with an example.

Joining three or more tables in SQL

In this tutorial we learn to all about having Examples like as a SQL join three or more tables, Use multiple JOINs, Using Aliasing, Multi-table queries with JOINs, Inner Join with Three Tables or many more.

Also Read: sql join multiple tables with conditions

SQL join three or more tables based on a parent-child relationship

SELECT a.ord_num,b.shopper_name,a.shopper_code,
c.agent_code,b.shopper_city
FROM agents c,shopper b,requests a
WHERE b.shopper_city=c.working_area
AND a.shopper_code=b.shopper_code
AND a.agent_code=c.agent_code;

Use multiple JOINs in your query:

SELECT l.name AS subject_name,   
  t.last_name AS pupil_last_name, 
  st.last_name AS teacher_last_name 
FROM learning AS l  
JOIN subject s ON l.subject_id=s.id
JOIN pupil st ON l.pupil_id=st.id
JOIN teacher t ON l.teacher_id=t.id; 

Multiple Joins

SELECT users.full_name, books.title, checkouts.checkout_date
FROM users
INNER JOIN checkouts ON (users.id = checkouts.user_id)
INNER JOIN books ON (books.id = checkouts.book_id);

Using Aliasing

SELECT u.full_name, b.title, c.checkout_date
FROM users AS u
INNER JOIN checkouts AS c ON (u.id = c.user_id)
INNER JOIN books AS b ON (b.id = c.book_id);

How to join 3 or more tables in SQL?

Where Condition (Inner Join with Three Tables)

Select table1.ID ,table1.Name 
from Table1 inner join Table2 on Table1 .ID =Table2 .ID inner join Table3 on table2.ID=Table3 .ID  
where table1.Name=Table3.Name 

Multi-table queries with JOINs

Select query with INNER JOIN on multiple tables

SELECT column, another_table_column, …
FROM mytable
INNER JOIN another_table 
    ON mytable.id = another_table.id
WHERE condition(s)
ORDER BY column, … ASC/DESC
LIMIT num_limit OFFSET num_offset;

sql query join multiple tables

SELECT s.pupilname
    , s.pupilid
    , s.pupildesc
    , h.hallname
FROM pupils s
INNER JOIN hallprefs hp
    on s.pupilid = hp.pupilid
INNER JOIN halls h
    on hp.hallid = h.hallid

Inner Join with Three Tables

Select table1.ID ,table1.Name 
from Table1 inner join Table2 on Table1 .ID =Table2 .ID  
inner join Table3 on table2.ID=Table3 .ID 

I hope you get an idea about sql join multiple tables.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.