Sql join 3 tables

This article is tagged with: Sql join 3 tables and mysql

sql join 3 tables

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

sql join 3 tables

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

This article is tagged with: Sql join 3 tables and mysql