any way to this query , its very slow.

SELECT CMC_CLCL_CLAIM.CLCL_ID,
CMC_SBSB_SUBSC.SBSB_ID,
CMC_CLCL_CLAIM.CLCL_TOT_CHG,
CMC_CLCL_CLAIM.CLCL_TOT_PAYABLE,
CMC_CLCL_CLAIM.CLCL_CUR_STS,
CMC_CLCL_CLAIM.CLCL_LOW_SVC_DT,
CMC_CLCL_CLAIM.CLCL_HIGH_SVC_DT,
CMC_CLCL_CLAIM.PDPD_ID,
CMC_CDML_CL_LINE.CDML_COPAY_AMT,
CMC_CDML_CL_LINE.CDML_CHG_AMT,
CMC_CDML_CL_LINE.CDML_ALLOW,
CMC_CDML_CL_LINE.CDML_SEQ_NO
into adhocdb..JP_COPAY_ERRORS
FROM CMC_CLCL_CLAIM

INNER JOIN CMC_SBSB_SUBSC
ON CMC_CLCL_CLAIM.SBSB_CK = CMC_SBSB_SUBSC.SBSB_CK

INNER JOIN CMC_CDML_CL_LINE
ON CMC_CLCL_CLAIM.CLCL_ID = CMC_CDML_CL_LINE.CLCL_ID

INNER JOIN CMC_CLHP_HOSP
ON CMC_CLCL_CLAIM.CLCL_ID = CMC_CLHP_HOSP.CLCL_ID

WHERE

CMC_CDML_CL_LINE.SESE_ID In
('ARB','ARBP','ARBS','CCU','HOSP','HOS','HOLD','HOLP',
'ISOL','ICU','ICUP','ICUS','MATN','MPRN','NUR','PRB','PRBP',
'PRBS','PRBD','PRBR','RB','RBP','RBS','RBD','RBDR','SARB',
'SPRB','SRBR','SRB','SBDR','SKNU')
AND CMC_CLCL_CLAIM.CLCL_CL_SUB_TYPE='H'
and CMC_CLCL_CLAIM.CLCL_RECD_DT <= '07/01/2003' AND CMC_CLCL_CLAIM.CLCL_RECD_DT
>= '07/07/2003'

AND CMC_CLHP_HOSP.CLHP_FAC_TYPE = '1'
AND CMC_CLHP_HOSP.CLHP_BILL_CLASS IN ('E','U','S','3')
AND CMC_CLCL_CLAIM.CLCL_ID IN
(
SELECT A.CLCL_ID FROM CMC_CDML_CL_LINE A
INNER JOIN CMC_CDML_CL_LINE B
ON A.CLCL_ID = B.CLCL_ID
WHERE
A.CDML_SEQ_NO <> B.CDML_SEQ_NO
AND A.CDML_COPAY_AMT <> B.CDML_COPAY_AMT
)


The last inner query IN is to get from a detail table rows which have different
copay amount

example
111 will be selected in below case

claim_id sequence_no copay
111 1 10.0
111 2 20.0
222 1 100.0
222 2 100.0

Thank you!
dhaya