ÕâÌõSQLÓï¾äÔÚAccessÀïÃæΪʲô²»ÄÜÓÃ

UPDATE TableA SET newsTel = (Select newsTel from TableB Where TableA.newsID = TableB.newsID)

ÕâÌõSQLÓï¾äÔÚAccessÀïÃæΪʲô²»ÄÜÓÃѽ£¬Ò»Ö´ÐоÍÌáʾ˵±ØÐëÊÇÒ»¸ö¿É¸üеIJéѯ¡£

ÔÚSQL 2000ÀïÃæ¿ÉÒÔÕý³£Ö´Ðеġ£

---

SQL code:
UPDATE TableA SET newsTel =B.newsTel from TableA A,TableB B where A.newsID=B.newsID

---

¿ÉÄÜÊÇÓï·¨ÎÊÌâ

---

SQL code:
UPDATE TableA A SET newsTel =B.newsTel from TableB B where A.newsID=B.newsID

SQL

---

»¹ÊDz»ÐУ¬Õâ´ÎÌáʾÓï·¨´íÎó

Óï·¨´íÎ󣨲Ù×÷·û¶ªÊ§£©ÔÚ²éѯ±í´ïʽ'B.newsTel from TableB B'ÖÐ

---

accessÓï·¨,ÓësqlserverÓÐÉÔÐí²»Í¬

SQL code:
UPDATE TableA inner join UPDATE TableB
on TableA.newsID = TableB.newsID
set TableA.newsTel = TableB.newsTel

---

ÉÏÃæд´í-_-|
SQL code:
UPDATE TableA inner join TableB
on TableA.newsID = TableB.newsID
set TableA.newsTel = TableB.newsTel

---

UPDATEÓï¾äµÄÓï·¨´íÎó

ÒýÓÃ

accessÓï·¨,ÓësqlserverÓÐÉ