34,588
社区成员
发帖
与我相关
我的任务
分享
declare @str varchar(2000)
declare @cmd varchar(2000)
select @str=U_oldcode from OCRD where CARDCODE='2201019'
set @cmd='select * from XIAOSHOU5_xxzx where XXXXXXX in ('+@str+')'
exec(@cmd)
CREATE TABLE OCRD
(
U_oldcode VARCHAR(20),
CARDCODE VARCHAR(20)
)
INSERT INTO OCRD
SELECT '2204014','2201019' UNION ALL
SELECT 'aa','ss' UNION ALL
SELECT '2201009','2201019' UNION ALL
SELECT 'ww','dd'
select U_oldcode from OCRD where CARDCODE='2201019'
CREATE TABLE XIAOSHOU5_xxzx
(
code VARCHAR(20),
ID int
)
INSERT INTO XIAOSHOU5_xxzx
SELECT '2204014',2 UNION ALL
SELECT '2201009',3 UNION ALL
SELECT '33',4 UNION ALL
SELECT '33',5 UNION ALL
SELECT '33' ,8UNION ALL
SELECT '2204014',8
select * from XIAOSHOU5_xxzx where code in (select U_oldcode from OCRD where CARDCODE='2201019')
select * from XIAOSHOU5_xxzx where code in ('2204014','2201009')