亲们，这个sql要怎么写啊？

[xlh0053]

表a lqe01 lqe02
10001
10002
10003
10004
10005
.
.
.
10010

表b lpz03 lpz04 lpz05
10001 10002 100
10003 10005 800
10006 10010 300

我要怎么根据表B的lpz05来更新表A的lqe02字段，结果如下：
表a lqe01 lqe02
10001 100
10002 100
10003 800
10004 800
10005 800
10006 300
10007 300
10008 300
10009 300
10010 300

[MrYangkang]

update A set lqe02 = B.lpz05 from B where a.lqe01 =B.lqe03

[xlh0053]

补充一下，我的是oracle数据库

[函麻]

update a set a.lqe02=b.lpz05 from a,b where a.lqe01 =b.lqe03

[MrYangkang]

update A
set lqe02 = B.lpz05
from B where a.lqe01 =B.lqe03 OR a.lqe01 =B.lqe04 

[daiyueqiang2045]

update A
set lqe02 = B.lpz05
from B where a.lqe01>=B.lqe03 OR a.lqe01<=B.lqe04 

[xlh0053]

oracle的写法啊，没人用oracle吗

[莱昂纳多达芬奇]

oracle的写法，你要到oracle版块下面去问啊，问错地方还这么横么？ update A set lqe02 =(select lpz05 from B where B.id=A.id) where exists (select 1 from B where B.id= A.id)