This is telling me "invalid column name "FirstName & LastName" as it doesn't have a table it is coming from that i can see and i need that for this to work. I see the "Person.Person" has first & last name but it wasn't brought in when I asked for help the last few times

design query editor

Q$+$D Q$+$E

$$

$[.$

$$

SQLQuery$12.$sql $-$ S$...($SHIELAlshiel $(78))$

SQLQuery$5.$sql $-$ SHI...$($SHIELAlshiel $(66))*$

SQLQuery$3.$sql $-$ SHI...$($SHIELAlshiel $(72))*$

SELECT E$.$BusinessEntityID AS EmployeeID, P$.$FirstName, P$.$LastName,

D$.$Name AS DepartmentName,

EPH.RateChangeDate AS LastRaiseDate,

CASE WHEN EPH.RateChangeDate IS NULL OR EPH.RateChangeDate $$ DATEADD$($month$,-12,$ GETDATE$())$

THEN $\text{'}$No Raise in $12+$ Months'

ELSE $\text{'}$OK$\text{'}$ END AS RaiseStatus

FROM HumanResources. EmployeePayHistory EPH

JOIN Person. Person AS P ON E$.$BusinessEntityID $=$ P$.$BusinessEntityID

JOIN HumanResources.Employee E ON EPH.BusinessEntityID $=$ E$.$BusinessEntityID

JOIN HumanResources.EmployeeDepartmentHistory EDH ON E$.$BusinessEntityID $=$ EDH.BusinessEntityID

JOIN HumanResources.Department D ON EDH.DepartmentID $=$ D$.$DepartmentID

WHERE EDH. EndDate IS NULL

ORDER BY P$.$LastName, P$.$FirstName; $q,$

I

$\%$

Messages

Msg $4104,$ Level $16,$ state $1,$ Line $7$

The multi$-$part identifier. $"$E$.$BusinessEntityID" could not be bound.

Completion time: $2024-05-12$T$21$:$13$:$29\mathrm{.}3090921-05$:$00$

Now I$\text{'}$m getting "Multi$-$Part Identifier E$.$BusinessEntityID could not be bound. I have sent the same question over & over and nothing is helping me$.$