update b,a set b.A_RCDID = a.RCDID where a.B_RCDID = b.B_RCDID
update b,a set b.A_RCDID = a.RCDID where a.B_RCDID = b.B_RCDID这句不行呀, update 不可以支持 两个表的呀。 请回复,谢谢!
update b set b.A_RCDID = a.A_RCDID from a,b where a.B_RCDID = b.B_RCDID
Update 表B B set B.A_RCDID=nvl(A.A_RCDID,0) where exists( select 1 from 表A A where B.B_RCDID=A.B_RCDID(+) )
update 表B B set b.A_RCDID=(select nvl(A.ARCDID,0) from 表A A where B.B_RCDID=A.B_RCDID)
这个问题我在access中遇到过,并愉快的解决了方法如下: update a,b set a.A_RCDID = b.a.RCDID where (a.B_RCDID = b.B_RCDID) 在access中是可以的但在oracle中没试过. 你的关联字段应是B_RCDID 吧!
这样就可以了。。UPDATE B SET A_RCDID = (SELECT A_RCDID FROM A WHERE A.B_RCDID = B.B_RCDID ) WHERE B_RCDID IN (SELECT B_RCDID FROM A)
Update B set B.A_RCDID=nvl(A.A_RCDID,0) where exists( select 1 from A where B.B_RCDID=A.B_RCDID(+) )
UPDATE B SET A_RCDID = (SELECT A_RCDID FROM A WHERE A.B_RCDID = B.B_RCDID ) ; 这样就行了!
这个和SQLSERVER有区别用EXISTSUpdate B set B.A_RCDID=A.A_RCDIDwhere exists(select * from Awhere B_RCDID=B.B_RCDID )
select a.a_rcdid,b.b_rcdid from a a inner join b b on a.b_rcdid=b.b_rcdid union select a.b_rcdid, b.b_rcdid from a a inner join b b on a.b_rcdid=b.a_rcdid where b.b_rcdid not in(select b_rcdid from a )试试这个,这个通过啦,
请回复,谢谢!
set b.A_RCDID = a.A_RCDID
from a,b
where a.B_RCDID = b.B_RCDID
set B.A_RCDID=nvl(A.A_RCDID,0)
where exists(
select 1
from 表A A
where B.B_RCDID=A.B_RCDID(+)
)
set b.A_RCDID=(select nvl(A.ARCDID,0)
from 表A A
where B.B_RCDID=A.B_RCDID)
update a,b set a.A_RCDID = b.a.RCDID where (a.B_RCDID = b.B_RCDID)
在access中是可以的但在oracle中没试过. 你的关联字段应是B_RCDID 吧!
SET A_RCDID = (SELECT A_RCDID
FROM A
WHERE A.B_RCDID = B.B_RCDID
)
WHERE B_RCDID IN (SELECT B_RCDID FROM A)
set B.A_RCDID=nvl(A.A_RCDID,0)
where exists(
select 1
from A
where B.B_RCDID=A.B_RCDID(+)
)
SET A_RCDID = (SELECT A_RCDID
FROM A
WHERE A.B_RCDID = B.B_RCDID
) ;
这样就行了!
)
b.b_rcdid from a a inner join b b on a.b_rcdid=b.a_rcdid where b.b_rcdid not
in(select b_rcdid from a )试试这个,这个通过啦,