subquery considered as table

Question

how can do assume sub query as table in mssql?

Answer 1

Hi,

Either you can use views or can create temporary table. to do this.

here is an example for inline view

SELECT * from (SELECT name, dob, city from user where state=1) as users where users.city=(select city from beautiful_cities LIMIT 1 ) order by user_id;