sql query with 3 joins code example
Example 1: sql join 3 tables
SELECT column-names
FROM table-name1 JOIN table-name2
ON column-name1 = column-name2
WHERE condition
Example 2: 3 joins in sql
SELECT e.FIRST_NAME ,
d.DEPARTMENT_NAME ,
l.CITY ,
c.COUNTRY_NAME ,
r.REGION_NAME
FROM EMPLOYEES e
INNER JOIN DEPARTMENTS d on e.DEPARTMENT_ID = d.DEPARTMENT_ID
INNER JOIN LOCATIONS l on l.LOCATION_ID = d.LOCATION_ID
INNER JOIN COUNTRIES c on l.COUNTRY_ID = c.COUNTRY_ID
INNER JOIN REGIONS r on c.REGION_ID = r.REGION_ID ;