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. RRS feed

  • 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?

    Thursday, July 26, 2018 3:22 AM

All replies

  • 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/

    Thursday, July 26, 2018 7:27 AM