急求一个sql语句，在线等

[happyscj]

1、SELECT id FROM layers WHERE name = 'GL_PL'
得到结果232
下面这个sql语句查的表名是f加上上面查出的结果，也就是f232
2、SELECT aid FROM f232

能把这两句合成一句吗

[--小F--]

这样的需求真少见

[liangCK]

declare @id  int
set @id=(select id from layers where name='gl_pl');

exec('select aid from [f'+@id+']')

[icelovey]

SELECT P.ID AS AID
FROM (SELECT id FROM layers WHERE name = 'GL_PL' ) AS P

[sgtzzc]

declare @sql varchar(8000)

select 
  @sql=isnull(@sql,'')+'select aid from [f'+ltrim(id)+']' 
from
  layers 
WHERE 
  name = 'GL_PL' 

exec (@sql)

[十一文]

SELECT aid FROM f232 ;SELECT id FROM layers WHERE name = 'GL_PL'
这样也是一句 但是是两个结果集

[icelovey]

晕,看错题目

[十一文]

[Quote=引用 5 楼 xming4321 的回复:]
SELECT aid FROM f232 ;SELECT id FROM layers WHERE name = 'GL_PL'
这样也是一句 但是是两个结果集

[/Quote]

汗我弄错需求了

[icelovey]

[Quote=引用 2 楼 liangck 的回复:]
SQL codedeclare@idintset@id=(select idfrom layerswhere name='gl_pl');exec('select aid from [f'+@id+']')
[/Quote]
CK的是对的, 只有动态语句才能解决吧

[好汉坡]

declare @name varchar(1000)

set @name='f'+ltrim((SELECT id FROM layers WHERE name = 'GL_PL'))

exec('SELECT aid FROM'+@name)

[icelovey]

declare @name varchar(1000)

set @name='f'+ltrim((SELECT id FROM layers WHERE name = 'GL_PL'))

exec('SELECT aid FROM'+@name)

[lang071234]

都拿出来 用excel 处理更好。。我觉得·！

[--小F--]

declare @sql varchar(8000)

set @sql=isnull(@sql,'')+'select aid from [f'+ltrim(id)+']' 

exec (select @sql from layers WHERE name = 'GL_PL' )

[lang071234]

declare @name varchar(1000)

set @name='f'+ltrim((SELECT id FROM layers WHERE name = 'GL_PL'))

exec('SELECT aid FROM'+@name)

思路清晰。

[lookto]

学习一下了

[gaomiqzhi]

学习

[david0927cs2006]

declare @id  varchar(32)

set @id= cast((select id from layers where name='gl_pl') as varchar(32));

exec('select aid from [f'+@id+']')