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
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
sql语法
举报文章
请选择举报类型
补充说明
0/200
上传截图
格式支持JPEG/PNG/JPG,图片不超过1.9M