Проблема с запросом

[kalex_a]

Не подскажите как на Х++ написать такой запрос

 
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'

Спасибо заранее.