34,590
社区成员
发帖
与我相关
我的任务
分享请说明下列SQL语句的含义
请说明下列SQL语句的含义；
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)
)
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)
)
...全文
请发表友善的回复…
发表回复
lxf31 2003-09-18
- 打赏
- 举报
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)
)
这个不是建立表吗？
我说了许多废话，可是老兄你能不能把问题问的详细点啊
