How to make a SubQuery in T-SQL

If I can remember what went wrong I will write it here...

Ok here we go:

If you have a SubQuery dont forget to set the "as" after the subquery otherwise you get a criptic message from the editor....

More:

http://www.databasejournal.com/features/mssql/article.php/3464481/Using-a-Subquery-in-a-T-SQL-Statement.htm