SQL数据表连接

u010212202

于 2012-03-15 15:10:47 发布

阅读量81

点赞数

分类专栏： SQL 文章标签：二张表数据复制

本文链接：https://blog.csdn.net/u010212202/article/details/84169065

版权

SQL 专栏收录该内容

3 篇文章 0 订阅

订阅专栏


UPDATE hj_cy_jws u   
set yyid = (   
            SELECT hj.yyid    
            FROM hj_cy_jws jw JOIN hj_cy hj ON jw.grid = hj.grid    
            WHERE u.id = jw.id   
            )


UPDATE hj_cy_jws u   
set yyid = (   
            SELECT DISTINCT hj.yyid    
            FROM hj_cy_jws jw JOIN hj_cy hj ON jw.grid = hj.grid    
            WHERE u.grid = hj.grid   
            )   
WHERE EXISTS (   
              SELECT * FROM hj_cy_jws jw JOIN hj_cy hj ON jw.grid = hj.grid   
              WHERE u.grid = hj.grid   
              )