Код

SELECT _1SBKTTL_vt.ACCID Счет
, _1SBKTTL_vt.SC0 Субконто1
, Cast(sd AS Numeric(15,2)) * iif(KIND = '1',1,0) СуммаОстаток1
, iif(KIND = '1',Cast(sd AS Numeric(15,2)),0) СуммаОстаток
, iif(KIND = '4',Cast(sd AS Numeric(15,2)),0) ВалютнаяСуммаОстаток

	FROM 1SACCS AS sq_vk
		LEFT JOIN 1SACCS AS _1SACCS_vt  ON (_1SACCS_vt.SCHKOD >= sq_vk.SCHKOD) AND (Left(_1SACCS_vt.SCHKOD, Len(sq_vk.SCHKOD)) = sq_vk.SCHKOD) AND (_1SACCS_vt.PLANID = '  MH') AND ((sq_vk.ID = '    9V   '))
		LEFT JOIN 1SBKTTL AS _1SBKTTL_vt  ON (_1SBKTTL_vt.ACCID = _1SACCS_vt.ID)
	WHERE (dtos(_1SBKTTL_vt.DATE) = '20090101')
		AND (_1SBKTTL_vt.KIND in ('1','4'))