34,576
社区成员
发帖
与我相关
我的任务
分享
select b.*
from a,b
where a.a1 = b.b1
select b.*
into c --结果生成表c
from a , b
where a.a1 = b.b1
update b --用a表更新b表
set b.b3=a.a3
from a
where a.a1 = b.b1
update c set c3 = b.b3 from c , a , b where c.c1 = a.a1 and a.a1 = b.b1
--1
select a.* , b.* from a , b where a.a1 = b.b1
--2
update c set c3 = b.b3
from c , a , b
where c.c1 = a.a1 and a.a1 = b.b1
select * from
(select a.a1,b.b2 from a,b where a.a1=b.b1)
into c
select b.b1,b.b2,b.b3 as a3
from a,b
where a.a1=b.b1