处理采购价格表重复

select case CGJGB2_JGLX WHEN 1 THEN '合同价' WHEN 0 then '临时价' else '其它单价' END 价格类型, 
CGJGB1_ZDRQ 单据日期,CGJGB1_DJBH 单据编号,CGJGB1_LSBH 流水编号,CGJGB1_DWBH 单位编码,ZWWLDW_DWMC 单位名称,
CGJGB1_ZDR 制单人,CGJGB2_WLBH 物料编号,LSWLZD_WLMC 物料名称,round(CGJGB2_DJ,3) 单价,round(CGJGB2_DJFLJE,3) 协议单价,
CGJGB2_QYRQ 启用日期,CGJGB2_KSRQ 开始日期,CGJGB2_JSRQ 结束日期,CGJGB2_BZ 备注,CGJGB1_SHBZ 审核标志,CGJGB1_SHXM 审核人
from CGJGB1,CGJGB2,ZWWLDW,LSWLZD 
where  CGJGB1_LSBH=CGJGB2_LSBH AND CGJGB2_WLBH+CGJGB1_DWBH+CGJGB2_KSRQ+CGJGB2_JSRQ+CGJGB1_DJZT
IN(
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)
AND CGJGB2_WLBH=LSWLZD_WLBH AND CGJGB1_DWBH=ZWWLDW_DWBH
AND ZWWLDW_DWMC='成都市明过机电有限公司' ORDER BY CGJGB2_WLBH



SELECT * FROM CGJGB1,CGJGB2 WHERE CGJGB1_LSBH=CGJGB2_LSBH AND CGJGB2_WLBH='A97006100'
AND CGJGB1_DJZT=1 

select * from CGJGB2 where CGJGB2_LSBH='4264' and CGJGB2_WLBH='A97006100'

update CGJGB2 set CGJGB2_JSRQ='20231225' where CGJGB2_LSBH='4264' and CGJGB2_WLBH='A97006100'


select case CGJGB2_JGLX WHEN 1 THEN '合同价' WHEN 0 then '临时价' else '其它单价' END 价格类型, 
CGJGB1_ZDRQ 单据日期,CGJGB1_DJBH 单据编号,CGJGB1_LSBH 流水编号,CGJGB1_DWBH 单位编码,ZWWLDW_DWMC 单位名称,
CGJGB1_ZDR 制单人,CGJGB2_WLBH 物料编号,LSWLZD_WLMC 物料名称,round(CGJGB2_DJ,3) 单价,round(CGJGB2_DJFLJE,3) 协议单价,
CGJGB2_QYRQ 启用日期,CGJGB2_KSRQ 开始日期,CGJGB2_JSRQ 结束日期,CGJGB2_BZ 备注,CGJGB1_SHBZ 审核标志,CGJGB1_SHXM 审核人
from CGJGB1,CGJGB2,ZWWLDW,LSWLZD 
where  CGJGB1_LSBH=CGJGB2_LSBH AND CGJGB2_WLBH+CGJGB1_DWBH+CGJGB2_KSRQ+CGJGB2_JSRQ+CGJGB1_DJZT
IN(
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)
AND CGJGB2_WLBH=LSWLZD_WLBH AND CGJGB1_DWBH=ZWWLDW_DWBH
AND ZWWLDW_DWMC='成都市明过机电有限公司' AND CGJGB1_LSBH='7744'

SELECT  * FROM CGJGB2 WHERE CGJGB2_LSBH=7744 AND 
CGJGB2_WLBH IN
(select CGJGB2_WLBH
from CGJGB1,CGJGB2,ZWWLDW,LSWLZD 
where  CGJGB1_LSBH=CGJGB2_LSBH AND CGJGB2_WLBH+CGJGB1_DWBH+CGJGB2_KSRQ+CGJGB2_JSRQ+CGJGB1_DJZT
IN(
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)
AND CGJGB2_WLBH=LSWLZD_WLBH AND CGJGB1_DWBH=ZWWLDW_DWBH
AND ZWWLDW_DWMC='成都市明过机电有限公司' AND CGJGB2_LSBH='7744')

DELETE FROM CGJGB2 WHERE CGJGB2_LSBH=7773 AND 
CGJGB2_WLBH IN
(select CGJGB2_WLBH
from CGJGB1,CGJGB2,ZWWLDW,LSWLZD 
where  CGJGB1_LSBH=CGJGB2_LSBH AND CGJGB2_WLBH+CGJGB1_DWBH+CGJGB2_KSRQ+CGJGB2_JSRQ+CGJGB1_DJZT
IN(
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)
AND CGJGB2_WLBH=LSWLZD_WLBH AND CGJGB1_DWBH=ZWWLDW_DWBH
AND ZWWLDW_DWMC='成都市明过机电有限公司' AND CGJGB2_LSBH='7773')


SELECT  * FROM KCRKD1 WHERE KCRKD1_LSBH IN(
select KCRKD2_LSBH from KCRKD2 WHERE KCRKD2_PCH='' )

SELECT  * FROM KCCKD1 WHERE KCCKD1_LSBH IN(
SELECT  KCCKD2_LSBH FROM KCCKD2 WHERE KCCKD2_PCH='')


update KCCKD2 set KCCKD2_PCH='240203' WHERE KCCKD2_PCH=''
UPDATE KCRKD2 SET KCRKD2_PCH='240203' WHERE KCRKD2_PCH='' AND KCRKD2_WLBH='A88206000'


update CGJGB2 SET CGJGB2_DJ=CGJGB2_DJFLJE where CGJGB2_DJFLJE<>0