sql join 3 tables
snippet in sql

join three tables in sql

user215

select s_name, score, status, address_city, email_id,
accomplishments 
from student s 
inner join marks m on s.s_id = m.s_id 
inner join details d on d.school_id = m.school_id;

sql join 3 tables

user7906

SELECT column-names
  FROM table-name1 JOIN table-name2 
    ON column-name1 = column-name2
 WHERE condition

sql join 3 tables

user6767

SELECT s.studentname
    , s.studentid
    , s.studentdesc
    , h.hallname
FROM students s
INNER JOIN hallprefs hp
    on s.studentid = hp.studentid
INNER JOIN halls h
    on hp.hallid = h.hallid