Stuff

SELECT dbo.Company.ID AS Expr1, dbo.Company.Name AS Company, dbo.BillingServiceInformation.ShortName, dbo.BillingServiceStatusCodes.ShortDesc, dbo.BillingServiceStatusCodes.WarningFlag, dbo.BillingServiceStatusCodes.StatusDescription, dbo.Company.CreditStatusID, dbo.BillingServiceStatusCodes.StatusCode, dbo.BillingServiceCustomers.BillingServiceID, dbo.BillingServiceInformation.Name FROM dbo.BillingServiceStatusCodes INNER JOIN dbo.Company INNER JOIN dbo.BillingServiceCustomers ON dbo.Company.ID = dbo.BillingServiceCustomers.FDCompanyID ON dbo.BillingServiceStatusCodes.ID = dbo.BillingServiceCustomers.CreditStatusID INNER JOIN dbo.BillingServiceInformation ON dbo.Company.BillingServiceID = dbo.BillingServiceInformation.ID WHERE (dbo.Company.ID = 13790)