declare @T table(id int,names varchar(20),sid int) insert into @T select 1,'大连市',21declare @B table(sid int,names varchar(20)) insert into @B select 21,'辽宁省' select a.* from @T a,@B b where a.sid=b.sid and b.names='辽宁省'
select name from table1,table2 where table1.sid=table2.sid; 能达到你要的效果 显示的事情自己搞定
declare @T table(id int,names varchar(20),sid int)
insert into @T select 1,'大连市',21declare @B table(sid int,names varchar(20))
insert into @B select 21,'辽宁省' select a.* from @T a,@B b where a.sid=b.sid and b.names='辽宁省'