请教一嵌套查询SQL语句

由于有些表的所有者不同，所以我先用以下sql   获得所有者  
   
  select     sysusers.name+'.'+sysobjects.name   as   'tablename'   from   sysobjects  
  inner   join   sysusers   on   sysobjects.name='tablename'   and   sysobjects.uid=sysusers.uid  
   
  结果成功获得   所有者.表格名  
   
   
  但想嵌套查询时我用  
  select   *   from     (select     sysusers.name+'.'+sysobjects.name   as   'tablename'   from   sysobjects  
  inner   join   sysusers   on   sysobjects.name='tablename'   and   sysobjects.uid=sysusers.uid)    
   
  结果不能通过，请问如何修改！谢谢！ 问题点数：20、回复次数：2Top

1 楼xeqtr1982（Visual C# .NET）回复于 2006-03-01 17:03:20 得分 10

select   a.*   from     (select     sysusers.name+'.'+sysobjects.name   as   'tablename'   from   sysobjects  
  inner   join   sysusers   on   sysobjects.name='tablename'   and   sysobjects.uid=sysusers.uid)   aTop

2 楼mislrb（上班看看早报，上上CSDN，下班看看电影）回复于 2006-03-01 17:21:30 得分 10

--都知道表名了，这样做好像没什么意义吧  
   
  declare   @tablename   varchar(10)  
  select   @tablename=(select     sysusers.name+'.'+sysobjects.name   as   'tablename'   from   sysobjects   inner   join   sysusers   on   sysobjects.name='t_a'   and   sysobjects.uid=sysusers.uid)  
  exec('select   *   from   '+   @tablename)  
   
  Top

相关问题

• sysusers
• sysobjects
• sysobjectsinner
• tablename
• uid
• 所有者
• join
• select

• 帖主：ufo20020427
• xeqtr1982
• mislrb

• SQL Server类图书