Trying to write a query for the following:I want a list of employees in the east and west regions and I need the full region name, not just the region ID.

Question

i wrote this but I got an error.

SELECT EmployeeT,EmployeeFirstName,EmployeeLastName,RegionOfficeT,RegionName, RegionID
FROM EmployeeT
INNER JOIN RegionOfficeT ON EmployeeT,RegionID = RegionName="East'

where did I go wrong?

Answer 1

There is no WHERE-clause and the JOIN is not specified the right way.

SELECT EmployeeFirstName,EmployeeLastName,,RegionName, RegionOfficeT.RegionID

FROM EmployeeT

INNER JOIN RegionOfficeT ON EmployeeT.RegionID = RegionOfficeT.RegionID

WHERE RegionName="East" OR RegionName="West"

---

Groeten, Peter http://access.xps350.com/