;merge into tb as a using(select * from tb where cwnames is not null) as b on a.dbno_bi=b.dbno_bi and a.cwnames is null when matched then update set a.cwnames =b.cwnames
merge into tb as a using(select * from tb where cwnames is not null) as b on a.dbno_bi=b.dbno_bi and a.cwnames is null when matched then update set a.cwnames =b.cwnames
UPDATE db SET db.qsq = a.qsq,db.cwnames=a.cwnames FROM db, (SELECT dbno_bi,qsq,cwnames FROM db WHERE cwnames IS NOT NULL)a WHERE db.dbno_bi =a.dbno_bi AND db.cwnames IS NULL
SELECT db.dbno,db.dbno_bi,a.qsq,a.cwnames FROM db, (SELECT dbno_bi,qsq,cwnames FROM db WHERE cwnames IS NOT NULL)a WHERE db.dbno_bi =a.dbno_bi AND db.cwnames IS NULL
发帖了不能编辑的啊 SELECT db.dbno,db.dbno_bi,a.qsq,a.cwnames FROM db, (SELECT dbno_bi,qsq,cwnames FROM db WHERE cwnames IS NOT NULL)a WHERE db.dbno_bi =a.dbno_bi
using(select * from tb where cwnames is not null) as b
on a.dbno_bi=b.dbno_bi and a.cwnames is null
when matched then update set a.cwnames =b.cwnames
using(select * from tb where cwnames is not null) as b
on a.dbno_bi=b.dbno_bi and a.cwnames is null
when matched then update set a.cwnames =b.cwnames
UPDATE db
SET db.qsq = a.qsq,db.cwnames=a.cwnames
FROM db,
(SELECT dbno_bi,qsq,cwnames FROM db WHERE cwnames IS NOT NULL)a
WHERE db.dbno_bi =a.dbno_bi AND db.cwnames IS NULL
SELECT db.dbno,db.dbno_bi,a.qsq,a.cwnames
FROM db,
(SELECT dbno_bi,qsq,cwnames FROM db WHERE cwnames IS NOT NULL)a
WHERE db.dbno_bi =a.dbno_bi AND db.cwnames IS NULL
SELECT db.dbno,db.dbno_bi,a.qsq,a.cwnames
FROM db,
(SELECT dbno_bi,qsq,cwnames FROM db WHERE cwnames IS NOT NULL)a
WHERE db.dbno_bi =a.dbno_bi