update table1 set A=table2.B where table1.id=table2.id--更新表
drop table A--删除表
select sum(a.kcje) as kcje,
sum(a.kcje*b.shlv/100) as kcsj,
sum(b.lshj*a.kcshl) as lshe
from spkfjc a,spkfk b where a.spid=b.spid and b.beactive='是'
Select djbh,spid,dwbh from ywmxk where djbh like ‘XS%’
--这分明是两个查询吗?
Create table spkfk(
Spid char (11),
Spbh char (10),
Spmch char (10)
)
这个不是建立表吗?我说了许多废话,可是老兄你能不能把问题问的详细点啊
drop table A--删除表
select sum(a.kcje) as kcje,
sum(a.kcje*b.shlv/100) as kcsj,
sum(b.lshj*a.kcshl) as lshe
from spkfjc a,spkfk b where a.spid=b.spid and b.beactive='是'
Select djbh,spid,dwbh from ywmxk where djbh like ‘XS%’
--这分明是两个查询吗?
Create table spkfk(
Spid char (11),
Spbh char (10),
Spmch char (10)
)
这个不是建立表吗?我说了许多废话,可是老兄你能不能把问题问的详细点啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货