Question

SQL: Can someone please help me ASAP??

I need to create QUERIES for 2 INNER JOINS with 3 or more tables. I have an HR Database with the tables Region, Location, Country, Job, Department, Employee, Dependent.

Any help would be greatly appreciated...

Answer 1

Given just a demo of it.

Replace Region table with your important table and remaining with your remaining tables.After the keyword "FROM" your important table or the table which you are using for joining remaining tables on it should be written.

The syntax is as follows just replace with your required ones.It will work for sure.

If any errors occur just drop a comment then will be glad to help you. thank You:)

SELECT Region.RegionID, Location.LocationId, Job.JobId
FROM ((Region
INNER JOIN Location ON Region.RegionID= Location.LocationId)
INNER JOIN Job ON Region.RegionID = Job.JobId);