**复制相同记录，更换编号***

[bigmingming]

A表
no item je
A01 aa 10


B表
No
A01
B01
C01
..
..


想复制相同记录，只是编号换一下

复制成
A表
no item je
A01 aa 10
B01 aa 10
C01 aa 10

[bigmingming]

顶一下！！！

[zhenshz]

试一下这个看下能不能实现

select a.a,b.je,b.sl from (
select 'A01' as a union all
select 'B01' union all
select 'C01'
) as a full join (
select  'A01' item, 'aa'  je, 10 sl
) as b on 1=1

[lzw_0736]

WITH a (no,item,je) AS
(
SELECT 'A01','aa','10'
)
,b (No) AS
(
SELECT 'A01' UNION ALL
SELECT 'B01' UNION ALL
SELECT 'C01'
)
SELECT b.no,a.item,a.je
FROM a,b

[bigmingming]

能否动态B表数量是不定的

[Ekun_sky]

with a(no,item,je) as
(select 'A01','aa',10),b(no) as
(select 'A01' union all
 select 'B01' union all
 select 'C01')
select b.no,a.item,a.je from a,b

[Ginnnnnnnn]

如果 A表只有一条数据 那可以直接

SELECT a.[no],b.item,b.je
	FROM B表 a
		CROSS APPLY(SELECT item,je FROM A表) AS b

如果说你要01对01那样的话

SELECT a.[no],b.item,b.je
	FROM B表 a
		INNER JOIN A表 b ON RIGHT(a.[NO],2)=RIGHT(b.[no],2)

[chen357313771]

CROSS JOIN ？？？？？

[天堂的鸽子]

with ta(no,item,je)
as
(select 'A01','aa',10),
tb(No)
as
(select 'A01' union all
 select 'B01' union all
 select 'C01')
select b.no,a.item,a.je from tb b cross join ta a

结果： no item je A01 aa 10 B01 aa 10 C01 aa 10