Murray Brown
asked on
SQL Duplicate records in statement compared to View
The following SQL Statement creates twice as many records as the underlying View vPerformanceHolesDelays. What might I be doing wrong? Could it be duplicates in one of the tables?
SELECT vPerformanceHolesDelays.*, p1.Surname AS [Foreman Name], p2.Surname AS [Supervisor Name], p3.Surname AS [Mach Operator], p4.Surname AS [Assist Operator], p5.Surname As [Assist Operator 2], p6.Surname As [Assist Operator 3]
FROM vPerformanceHolesDelays Left Join People AS p1 ON [vPerformanceHolesDelays].[Foreman] = p1.[Operator COY] Left Join People AS p2 ON [vPerformanceHolesDelays].[Supervisor] = p2.[Operator COY] Left Join People AS p3 ON vPerformanceHolesDelays.[Machine Operator] = p3.[Operator COY] Left Join People AS p4 ON [vPerformanceHolesDelays].[Assistant Operator] = p4.[Operator COY] Left Join People AS p5 ON vPerformanceHolesDelays.[Assistant Operator 2] = p5.[Operator COY] Left Join People AS p6 ON [vPerformanceHolesDelays].[Assistant Operator 3] = p6.[Operator COY]
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER