Sql join 3 tables

-- 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 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

13 votes320 views5 answers
Alter table query sql server change column
SQL
0 vote290 views1 answer
T-SQL - Where Used List (Table/View)
SQL
7 votes304 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote306 views1 answer
Postgresql on conflict pair
SQL
0 vote327 views1 answer
Primary key start from number
SQL
0 vote300 views2 answers
How covert into int in maria db
SQL
-1 vote301 views5 answers
Online sql to linq generator
SQL
1 vote323 views1 answer
Drop primary key oracle
SQL
2 votes275 views1 answer
Username sql
SQL
15 votes397 views5 answers
Select all tables sql
SQL