[kalex_a]

Оставил два no exists join, на сервер уходит вот такой запрос:

declare @p1 int
set @p1=1073742866
declare @p2 int
set @p2=180158983
declare @p5 int
set @p5=16
declare @p6 int
set @p6=1
declare @p7 int
set @p7=-1
exec sp_cursorprepexec @p1 output,@p2 output,N'@P1 nvarchar(8),@P2 int,@P3 nvarchar(2002),@P4 nvarchar(8),@P5 nvarchar(8)',N'SELECT 
A.REQUESTID,A.CURRENCYCODE,A.DIMENSION,A.DIMENSION2_,A.DIMENSION3_,A.DIMENSION4_,A.DIMENSION5_,A.DIMENSION6_,A.DIMENSION7_,A.CONFIRM_LABEL1,A.CONFIRM_COSTCONTROL,A.CONFIRM_FINAL,A.DATECONFIRM_LABEL1,A.DATECONFIRM_COSTCONTROL,A.DATECONFIRM_FINAL,A.USERCONFIRMLABEL1,A.USERCONFIRM_COSTCONTROL,A.USERCONFIRM_FINAL,A.AMMOUNT,A.USER_REGISTR,A.DATE_REGISTR,A.FIELD1,A.ID_COMPETENCE,A.REQUESTID_REZERV,A.ATF_TYPEREQUEST,A.AMMOUNT_BALANS,A.VENDACCOUNT,A.VENDRNN,A.VENDNAME,A.CONTRACTDATE,A.CONTRACTNUMBER,A.DATECONFIRM_TOPAY,A.USERCONFIRM_TOPAY,A.AMMOUNT_PAYMENT,A.CONFIRM_TOPAY,A.REQUESTURL,A.MODIFIEDDATE,A.MODIFIEDTIME,A.MODIFIEDBY,A.CREATEDDATE,A.CREATEDTIME,A.CREATEDBY,A.RECVERSION,A.RECID,A.REQUEST_TEXT 
FROM PURCHTABLE_REQUEST A WHERE ((A.DATAAREAID=@P1) AND ((A.CONFIRM_FINAL=@P2) AND  NOT ((A.REQUESTURL=@P3)))) AND NOT EXISTS (SELECT ''x'' FROM PURCHTABLE B WHERE 
((B.DATAAREAID=@P4) AND (A.REQUESTID=B.REQUESTID)) AND NOT EXISTS (SELECT ''x'' FROM PURCHLINE C WHERE ((C.DATAAREAID=@P5) AND (A.REQUESTID=C.REQUESTID)))) ORDER BY A.DATAAREAID 
DESC,A.DATECONFIRM_FINAL DESC OPTION(FAST 1)',@p5 output,@p6 output,@p7 output,N'dat',1,N'',N'dat',N'dat'
select @p1, @p2, @p5, @p6, @p7

но фильтрует только по первому (PurchTable).

Не пойму в чем проблема.