- A+
所属分类:Oracle
SQL UPDATE语句
- UPDATE table1 t1
- SET (name, desc) = (SELECT t2.name, t2.desc
- FROM table2 t2
- WHERE t1.id = t2.id)
- WHERE EXISTS (
- SELECT 1
- FROM table2 t2
- WHERE t1.id = t2.id )
比对两个库数据语句
- select t1.sb_com_num,t2.sb_com_num from sb_base t1,sb_base_linshi t2 where t1.sb_id =t2.sb_id and t1.sb_com_num<>t2.sb_com_num