SQLServerCentral / SQL Server 7,2000 / T-SQL / using outer query column name in subquery while doing order by / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 05:13:31 GMT20RE: using outer query column name in subquery while doing order byhttp://www.sqlservercentral.com/Forums/Topic855974-8-1.aspxPlease post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.[url]http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]Sat, 30 Jan 2010 05:14:52 GMTGilaMonsterRE: using outer query column name in subquery while doing order byhttp://www.sqlservercentral.com/Forums/Topic855974-8-1.aspxSome ids of student table will present in school table...i am not dding inner join..if i go for inner join..will get all rows which were common based on idSat, 30 Jan 2010 05:07:22 GMTganaparthi.jagadeeshRE: using outer query column name in subquery while doing order byhttp://www.sqlservercentral.com/Forums/Topic855974-8-1.aspxYou're basically doing an inner join between <Student> and <School> on ID columns. Are IDs unique across these two tables?Fri, 29 Jan 2010 08:17:05 GMTRP_DBAusing outer query column name in subquery while doing order byhttp://www.sqlservercentral.com/Forums/Topic855974-8-1.aspxusing outer query column name in subquery while doing order by caluseex: Select name,id,school from <Student>where id in(select top 5 id from <Somtable> order by school)school name is not present in <Sometable>will it work...i experinced this type situation.it has worked.can any one give reasons..how it is working..?Fri, 29 Jan 2010 05:17:40 GMTganaparthi.jagadeesh