Не подскажите как на Х++ написать такой запрос
Код:
select * from Ledgertrans as t2(nolock)
where voucher in
(select voucher
from dbo.RASSETTRANS as t1(nolock)
left join dbo.RASSETSTANDARDS as t2(nolock)
on t1.dataareaid=t2.dataareaid and t1.accountnum=t2.Assetid and t1.postingprofile=t2.postingprofile
where t1.AssetTransType in (5,6,7)
and t1.TransDate>='2009-01-01'
and t1.TransDate<'2009-02-01'
and t2.AssetGroup='группа'
)
and ACCOUNTNUM >'счет1'
and ACCOUNTNUM <'счет2'
Спасибо заранее.