【T-SQL】UPDATE和DELETE操作中使用INNER JOIN关联
摘要：
--UPDATE中INNER JOIN操作UPDATE A SET field='xxx' FROM table1 A INNER JOIN table2 B ON A.id=B.fkid WHERE..--DELETE中INNER JOIN操作DELETE FROM A FROM table1 A INNER JOIN table2 B ON A.id=B.fkid WHERE.. 阅读全文
posted @ 2011-06-24 10:24 Mr__BRIGHT 阅读(1604) 评论(0) 推荐(0) 编辑
