救命啊！SQL UPDATE 问题？(50分)

P

peleg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #1

跨表更改问题
update table1 set a1 = b.a1 from table2 b where a2 = b.a2
update table1 set a1 = b.a1 from table1 a ,table2 b where a.a2 = b.a2
都不能通过!delphi6.0 ado+access

 

D

dilot7

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #2

按照DELPHI的习惯写[]

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #3

update table1 a
set
a.a1=(select a1 from table2 b)
where a.a2=b.a2
access 好像不支持from

 

J

jsxjd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #4

Table1 Tabl2 必须是数据库表的名称，不能是数据库表控件 TTable

update table1 set a1 = table2.a1 from table1,table2 b where table1.a2 = table2.a2

 

Q

qianwt

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #5

在第一个语句后面加；号

 

P

peleg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #6

不行啊!

 

天

天真

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #7

由于ACCESS没有内存缓冲区所以不支持该写法，

 

P

peleg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #8

TO 天真
有没有其它办法了？

 

Y

ysai

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-27

• #9

ACCESS的语法不同
update table1 as a,table2 as b set a.a1 = b.a1 where a.a2 = b.a2

 

P

peleg

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-11-28

• #10

多人接受答案了。