Отбор по вычисляемому полю второй табицы

Здравствуйте, есть следующий запрос

SELECT 

t.*,

(select count(*) from USERRELEASES where USERRELEASES.RELEASE_ID=release.RELEASE_ID and USERRELEASES.USERRELEASE_CURRENTFLAG=1) as RELEASE_NBINSTALLED, 

(select sum(case when USERRELEASES.USERRELEASE_CURRENTFLAG=0 then 1 else 0 end) FROM USERRELEASES where USERRELEASES.RELEASE_ID=release.RELEASE_ID) as RELEASE_HISTORYNB, 

(select count(*) from RELEASES t2 where t2.VERSION_ID=t.VERSION_ID) as INSTALL_VERSION, 

release.*

 FROM [dbo].[VERSIONS] [t]  

LEFT OUTER JOIN [dbo].[RELEASES] [release] ON ([release].[VERSION_ID]=[t].[VERSION_ID])  

WHERE (t.VERSION_VERSION1<>99) 

Нужно отобрать ГДЕ RELEASE_NBINSTALLED > 0 и где меньше нуля

пробовал так

SELECT 

t.*,

(select count(*) from USERRELEASES where USERRELEASES.RELEASE_ID=release.RELEASE_ID and USERRELEASES.USERRELEASE_CURRENTFLAG=1) as RELEASE_NBINSTALLED, 

(select sum(case when USERRELEASES.USERRELEASE_CURRENTFLAG=0 then 1 else 0 end) FROM USERRELEASES where USERRELEASES.RELEASE_ID=release.RELEASE_ID) as RELEASE_HISTORYNB, 

(select count(*) from RELEASES t2 where t2.VERSION_ID=t.VERSION_ID) as INSTALL_VERSION, 

release.*

 FROM [dbo].[VERSIONS] [t]  

LEFT OUTER JOIN [dbo].[RELEASES] [release] ON ([release].[VERSION_ID]=[t].[VERSION_ID])  

WHERE (t.VERSION_VERSION1<>99) 

AND 

release.RELEASE_ID IN 

(select USERRELEASES.RELEASE_ID from USERRELEASES where USERRELEASES.RELEASE_ID=release.RELEASE_ID GROUP BY USERRELEASES.RELEASE_ID HAVING sum(USERRELEASES.USERRELEASE_CURRENTFLAG) > 0)

Работает только если нужно выбрать больше нуля работает, а меньше нет.

Помогите пожалуйста как решить этот вопрос