Delete and Update

来源:互联网 发布:c语言俄罗斯方块 编辑:程序博客网 时间:2024/06/07 23:47

DELETE A FROM Attachment A

INNER JOIN Material M ON A.MatID=M.MatID

WHERE M.AtrID=5




UPDATE A SET Name='附件一'

FROM Attachment A

INNER JOIN Material M ON A.MatID=M.MatID

WHERE M.AtrID=1


0 0
原创粉丝点击