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
