首页 > 编程学习 > Update Join delete JOIN

Update Join delete JOIN

发布时间:2022/8/31 11:18:42
UPDATE INNER JOIN

UPDATE A SET Name='whq'
FROM TableA AS A
INNER JOIN TableB AS B ON A.ID=B.ID
WHERE A.ID<1000 AND B.Type=2 
DELETE INNER JOIN

DELETE A
 FROM TableA AS A
INNER JOIN TableB AS B ON A.ID=B.ID
WHERE A.ID<1000 AND B.Type=2

  

Copyright © 2010-2022 mfbz.cn 版权所有 |关于我们| 联系方式|豫ICP备15888888号