[datfi]

Цитата:

Сообщение от a33ik

Можете предоставить SQL запрос, который Вы используете?

SELECT     CRMAF_FilteredNew_opis.new_accountopisidname, FilteredNew_docopis.new_naimenovaniedocopisidname, FilteredNew_docopis.new_kolichestvo, 
                      SystemUser.FullName, FilteredAccount.address1_city, FilteredAccount.address1_stateorprovince, SystemUser.Title, FilteredBusinessUnit.divisionname, 
                      CRMAF_FilteredNew_opis.createdon, FilteredAccount.address1_line1, FilteredBusinessUnit.parentbusinessunitidname, SystemUser.BusinessUnitIdName
FROM         FilteredAccount INNER JOIN
                      FilteredNew_opis AS CRMAF_FilteredNew_opis ON FilteredAccount.accountid = CRMAF_FilteredNew_opis.new_accountopisid INNER JOIN
                      FilteredNew_docopis ON CRMAF_FilteredNew_opis.new_opisid = FilteredNew_docopis.new_opis_docopisid INNER JOIN
                      SystemUser ON CRMAF_FilteredNew_opis.createdby = SystemUser.SystemUserId INNER JOIN
                      FilteredBusinessUnit ON SystemUser.BusinessUnitId = FilteredBusinessUnit.businessunitid