/SQL/How to join three tables in sql using joins

How to join three tables in sql using joins

-- Rows with ID existing in both a, b and c
-- JOIN is equivalent to INNER JOIN
SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a 
  JOIN table2 b ON a.ID = b.ID
  JOIN table3 c ON a.ID = c.ID
WHERE a.ID >= 1000;
-- ⇓ Test it ⇓ (Fiddle source link)

Source: sqlfiddle.com

Join multiple tables sql

SELECT TableA.*, TableB.*, TableC.*, TableD.*
FROM TableA
    JOIN TableB
        ON TableB.aID = TableA.aID
    JOIN TableC
        ON TableC.cID = TableB.cID
    JOIN TableD
        ON TableD.dID = TableA.dID
WHERE DATE(TableC.date)=date(now())

Source: stackoverflow.com

Join three tables sql

Suppose we are having three table named as 
Student_details
Attendance_details
Batch_details
And we have to apply join these three tables for fetching records

Example query:
select column_names
from Student_detail as s join Attendance_details as a on
s.s_id = a.s_id join Batch_details as b on 
s.s_id = b.s_id;

Here in the above example we implemented simple join but you change it with own join requirements.

Similar codes

11 votes161 views3 answers
Python sqlite3 create table if not exists
SQL
1 vote171 views1 answer
Cannot define PRIMARY KEY constraint on nullable column in table 'Student'.
SQL
2 votes150 views1 answer
Sql update from different table
SQL
1 vote180 views1 answer
Postgres cast as currency format
SQL
0 vote165 views1 answer
Mysql group by range
SQL
0 vote153 views1 answer
Can we rollback in sql
SQL
0 vote171 views1 answer
Format the money fied with comma in international system using sql
SQL
4 votes159 views3 answers
Employee name starting with in sql
SQL
20 votes155 views5 answers
Mysql reset auto increment to 1
SQL
10 votes150 views4 answers
Primary key in sql
SQL