Using multiple join in sql

This article is tagged with: Using multiple join in sql and mysql

using multiple join in sql

SELECT e.FIRST_NAME , -- coming from EMPLOYEES table
d.DEPARTMENT_NAME ,-- coming from DEPARTMENTS table
l.CITY , -- coming from LOCATIONS table
c.COUNTRY_NAME , -- coming from COUNTRIES table
r.REGION_NAME -- coming from REGIONS table
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 ;

join multiple tables sql

SELECT TableA.*, TableB.*, TableC.*, TableD.*
FROM TableA
JOIN TableB
ON TableB.aID = TableA.aID
JOIN TableC
ON TableC.cID = TableB.cID
JOIN TableD
ON TableD.dID = TableA.dID
WHERE DATE(TableC.date)=date(now())

This article is tagged with: Using multiple join in sql and mysql