求助:SQL语句
表1:
col1 col2
a a.1
b b.1
-------------------------
表2:
col1
a(001)
a(002)
a(003)
...
b(001)
b(002)
b(003)
...
-------------------------
由上面两表,如何根据SQL语句把原有的表1改成如下表
修改后的表1:
col1 col2
a(001) a(001).1
a(002) a(002).1
a(003) a(003).1
...
b(001) b(001).1
b(002) b(002).1
b(003) b(003).1
...
感觉把表2改成这样还比较好改
SQL code:
SELECT T2.COL1,T2.COL1+RIGHT(T1.COL2,2)AS COL2 INTO #T
from TB1 T1,TB2 T2 WHERE T1.COL1=LEFT(T2.COL1,1)
DELET TB1
INSERT TB1 SELECT * from #T
SQL code:
SELECT T2.COL1,T2.COL1+RIGHT(T1.COL2,2)AS COL2 INTO #T
from TB1 T1,TB2 T2 WHERE T1.COL1=LEFT(T2.COL1,1)
DELETE TB1
INSERT TB1 SELECT * from #T
SQL code
Code highlighting produced by Actipr
相关问答:
with adod_dict do
begin
close;
commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......
如题:select name from table1
得到结果:name
小王
小赵
小李
......
我想查出
month
1
2
3
4
5
6
7
8
9
10
11
12
这样的数据,如何实现啊。。。
SQL code:
select top 12 month=identity(int,1,1) into #t from sysobjects
selec ......
data a b c d e tag
2009-11-01 11 ......