20.11.2009, 18:04
|
#4
|
Чайный пьяница
Регистрация: 02.07.2008
Адрес: Greenville, SC
|
Цитата:
Сообщение от datfi
Код: 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
На первый взгляд всё верно. Вы можете сам rdl файлик выложить сюда?
|
|