Missing ),] or item in query expression

[Mike Hughes]

I'm getting error when I run this query can someone help?

Error is
Missing ),] or item in query expression A.CD_STATUS_RECEIPT="H" AND
A.DT_DISTRIBUTE Is Null AND
A.DT_END_VALIDITY=#12/31/9999# AND
A.AMT_TO_DISTRIBUTE BETWEEN 100 AND 500 AND

Not Exists (Select 1 from NOLDBA_RECEIPT K
where a.dt_batch = k.dt_batch
ANd a.no_batch = k.no_batch
And a.cd_source_batch = k.cd_source_batch
And a.seq_receipt = k.seq_receipt
And k.ind_backout = 'Y'
And k.dt_end_validity = #12/31/9999#)
And ((trim(A.Id_Case) IS NOT NULL
AND A.Id_case = b.case_id )
Or
( trim(A.Id_Case) IS NULL
ANd b.case_id = (Select Min(y.case_id) from NOLDBA_INT_CASE_STATUS Y, NOLDBA_RECEIPT Z
Where A.Id_Payor = z.member_id
And z.relation_code IN ('A','P')
And z.case_id = y.case_id )

This is the complete querySELECT B.WORKER_ID, B.IV_D_DO_CODE, A.ID_PAYOR, B.CASE_ID, A.DT_BATCH, A.CD_SOURCE_BATCH, A.NO_BATCH, A.SEQ_RECEIPT, A.CD_REASON_STATUS, Sum(A.AMT_TO_DISTRIBUTE) AS HELD_AMT

FROM NOLDBA_RECEIPT A, NOLDBA_INT_CASE_STATUS B

GROUP BY B.WORKER_ID, B.IV_D_DO_CODE, A.ID_PAYOR, B.CASE_ID, A.DT_BATCH, A.CD_SOURCE_BATCH, A.NO_BATCH, A.SEQ_RECEIPT, A.CD_STATUS_RECEIPT, A.CD_REASON_STATUS, A.DT_DISTRIBUTE, A.DT_END_VALIDITY, A.AMT_TO_DISTRIBUTE

HAVING
A.CD_STATUS_RECEIPT="H" AND
A.DT_DISTRIBUTE Is Null AND
A.DT_END_VALIDITY=#12/31/9999# AND
A.AMT_TO_DISTRIBUTE BETWEEN 100 AND 500 AND

Not Exists (Select 1 from NOLDBA_RECEIPT K
where a.dt_batch = k.dt_batch
ANd a.no_batch = k.no_batch
And a.cd_source_batch = k.cd_source_batch
And a.seq_receipt = k.seq_receipt
And k.ind_backout = 'Y'
And k.dt_end_validity = #12/31/9999#)
And ((trim(A.Id_Case) IS NOT NULL
AND A.Id_case = b.case_id )
Or
( trim(A.Id_Case) IS NULL
ANd b.case_id = (Select Min(y.case_id) from NOLDBA_INT_CASE_STATUS Y, NOLDBA_RECEIPT Z
Where A.Id_Payor = z.member_id
And z.relation_code IN ('A','P')
And z.case_id = y.case_id )

 

[jdraw]

There is no matching bracket for

( trim(A.Id_Case) IS NULL