Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

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]

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

Great answer! Thanks a lot