access数据更新(100分)

H

hhh77

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-24

• #1

数据表1: lsypkc 字段名：qckc,ypmcgg
数据表2: lsypkcbak 字段名:drkc,ypmc
目的: 将lsypkc表中ypmcgg与lsypkcbak表ypmc相等的记录的qckc用lsypkcbak中的drkc更新

说明：请实验后回答，access对SQL语句的写法与SQL2000中有所不同
update lsypkc set qckc=lsypkcbak.drkc from lsypkc,lsypkcbak
where lsypkc.ypmcgg=lsypkcbak.ypmc
这种写法在SQL2000里可以在ACCESS里不通过

 

碧

碧血剑

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-24

• #2

update lsypkc, lsypkcbak set lsypkcqckc=lsypkcbak.drkc where lsypkc.ypmcgg=lsypkcbak.ypmc

 

崔

崔占东

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-24

• #3

update lsypkc set lsypkc.qckc=lsypkcbak.drkc from lsypkc,lsypkcbak
where lsypkc.ypmcgg=lsypkcbak.ypmc
不能吧

 

碧

碧血剑

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-24

• #4

不好意思少了一个点
update lsypkc, lsypkcbak set lsypkc.qckc=lsypkcbak.drkc where lsypkc.ypmcgg=lsypkcbak.ypmc

 

H

hhh77

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-24

• #5

未报语法错误，但结果不正确！
请帮忙再试试

 

H

hhh77

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-24

• #6

对不起，刚才我看错了，结果是对的！

请问能否解释一下该语法呢？
谢谢！

 

碧

碧血剑

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-24

• #7

Access语法和标准SQL语法有些不同
Update语句就是这样的
update a, b set a.字段=b.字段 where a.id=b.id

 

H

hhh77

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-12-24

• #8

接受答案了.