SELECT dbo.tServiceID.ID AS ServiceIDID, dbo.tServiceID.ServiceID, dbo.tCentre.ID AS CentreID, dbo.tCentre.Description AS CentreDesc, dbo.tDepartment.ID As DeptID, dbo.tDepartment.Description AS DeptDesc, dbo.tGroup.ID AS GrpID, dbo.tGroup.Description AS GrpDesc, dbo.tCustomer.ID AS CustID, dbo.tCustomer.ShipTo, dbo.tCustomer.FullName FROM dbo.tServiceID INNER JOIN dbo.tCentre ON dbo.tServiceID.CustomerCentreID = dbo.tCentre.ID INNER JOIN dbo.tDepartment ON dbo.tCentre.DepartmentID = dbo.tDepartment.ID INNER JOIN dbo.tGroup ON dbo.tDepartment.GroupID = dbo.tGroup.ID INNER JOIN dbo.tCustomer ON dbo.tGroup.CustomerID = dbo.tCustomer.ID ORDER BY 1