Sql join

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

15 votes152 views1 answer
Mysql int range
SQL
20 votes164 views6 answers
Change password in mysql
SQL
2 votes200 views1 answer
Show max_allowed_packet mysql
SQL
0 vote160 views2 answers
Mysql multiply
SQL
0 vote169 views2 answers
Update query with between in mysql
SQL
0 vote165 views1 answer
Psql generate id in existing database
SQL
3 votes154 views4 answers
Mysql decimal
SQL
3 votes168 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote163 views1 answer
Create bdd mysql
SQL
1 vote176 views1 answer
Sql set auto increment back to 0
SQL