SELECT        TOP (100) PERCENT dbo.tabCustomers.Name AS [Название компании], dbo.tabCustomers.Description AS [Вид деятельности], dbo.tabCustomers.Comments, dbo.tabCountry.CountryName, dbo.tabCity.CityName, 
                         dbo.tabRegion.RegionName, dbo.tabCustomerAddress.Address, dbo.tabRecords.Date, dbo.tabRecords.Request, dbo.tabUsers.FirstName, dbo.tabCustomerAddressContact.Position AS Должность, 
                         dbo.tabCustomerAddressContact.LandPhone, dbo.tabCustomerAddressContact.CellPhone, dbo.tabCustomerAddressContact.Fax, dbo.tabCustomerAddressContact.email, dbo.tabCustomerAddressContact.Comment, 
                         dbo.tabCustomerAddressContact.Name, dbo.tabCustomerAddressContact.id, dbo.tabUsers.id AS Expr1, dbo.tabRoles.RoleName
FROM            dbo.tabRoles INNER JOIN
                         dbo.tabUsers ON dbo.tabRoles.id = dbo.tabUsers.id FULL OUTER JOIN
                         dbo.tabCustomers FULL OUTER JOIN
                         dbo.tabRecords ON dbo.tabCustomers.id = dbo.tabRecords.CustomerId FULL OUTER JOIN
                         dbo.tabCustomerAddress ON dbo.tabCustomers.id = dbo.tabCustomerAddress.id ON dbo.tabUsers.id = dbo.tabRecords.UserId FULL OUTER JOIN
                         dbo.tabCustomerAddressContact ON dbo.tabCustomers.id = dbo.tabCustomerAddressContact.id AND dbo.tabCustomerAddress.id = dbo.tabCustomerAddressContact.AddressID FULL OUTER JOIN
                         dbo.tabCity ON dbo.tabCustomers.id = dbo.tabCity.id FULL OUTER JOIN
                         dbo.tabRegion ON dbo.tabCustomers.id = dbo.tabRegion.id FULL OUTER JOIN
                         dbo.tabCountry ON dbo.tabCustomers.id = dbo.tabCountry.id
ORDER BY [Название компании] DESC