UPDATE TITLES SET PRICE=PRICE*1.05 WHERE PUB_ID IN(SELECT PUB_ID FROM PUBLISHERS)与这个等价的是
A UPDATE TITLES SET PRICE=PRICE*1.05 WHERE TITLES.PUB_ID= PUBLISHERS.PUB_ID
B UPDATE TITLES SET PRICE=PRICE*1.05 FROM TITLES INNER JOIN PUBLISHERS ON TITLES.PUB_ID= PUBLISHERS.PUB_ID
求答案求解析,谢谢了
A UPDATE TITLES SET PRICE=PRICE*1.05 WHERE TITLES.PUB_ID= PUBLISHERS.PUB_ID
B UPDATE TITLES SET PRICE=PRICE*1.05 FROM TITLES INNER JOIN PUBLISHERS ON TITLES.PUB_ID= PUBLISHERS.PUB_ID
求答案求解析,谢谢了
A UPDATE TITLES SET PRICE=PRICE*1.05 WHERE TITLES.PUB_ID= PUBLISHERS.PUB_ID沒指定表名會出錯改為加上From
UPDATE TITLES SET PRICE=PRICE*1.05 from PUBLISHERS WHERE TITLES.PUB_ID= PUBLISHERS.PUB_ID
---等同
UPDATE TITLES SET PRICE=PRICE*1.05 FROM TITLES INNER JOIN PUBLISHERS ON TITLES.PUB_ID= PUBLISHERS.PUB_ID