采购价格表核查合同价是否重复

select  CGJGB2_WLBH,CGJGB1_DWBH,CGJGB2_KSRQ,CGJGB2_JSRQ,CGJGB1_DJZT from CGJGB1,CGJGB2  where  CGJGB1_LSBH=CGJGB2_LSBH
and CGJGB1_DJZT=1 
group by  CGJGB2_WLBH,CGJGB1_DWBH,CGJGB2_KSRQ,CGJGB2_JSRQ,CGJGB1_DJZT
having count(*)>1