mooriginal
asked on
The correlation name 'ej' is specified multiple times in a FROM clause
Im trying to do this but keep getting the error shown in the title
Not sure what im missing
Not sure what im missing
select DISTINCT
e.EmployeeID,
es.EmployeeStatus AS Status,
e.EmployeeDescNoID AS Emp_Name,
e.WindowsUserName AS LoginID,
e.DisplayEmployeeID AS UserID,
e.ExtNoUD AS Extension,
e.FFWMobileUD AS FFWMobile,
e.WorkEmail AS Email,
-- profitcentre
-- department
e.EliteNoUD AS SectionNumber,
e.SecretaryNameUD AS Secretary,
e.LocationUD AS Location,
ej.PostID AS Position
FROM [Cascade].dbo.Employee e
JOIN [Cascade].dbo.EmployeeJobs ej
ON e.EmployeeID = ej.EmployeeID
JOIN [Cascade].dbo.Employee_Status es
ON e.EmployeeID = es.EmployeeID
LEFT OUTER JOIN (select t1.JobTitle, t1.EmployeeID
from [Cascade].dbo.EmployeeJobs t1
join (select employeeId, min(Sequence) as sequence
from [Cascade].dbo.EmployeeJobs
group by employeeID
) t2
on t1.employeeid = t2.employeeID
and t1.Sequence = t2.Sequence
) ej
ON e.EmployeeID = ej.EmployeeID
WHERE es.EmployeeStatus = 'Current'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
appari: is correct