Query that uses another Query within itself
Posted on 2011-05-11
OK, this is a weird question, and hopefully I will be able to explain it well enough to get some good advice.
This was originally an Access Database
#1 There was a Query that was made and SAVED with name: Query1
#2 There was another Query that was made, that used the Query1 within it.
select some, thing from table
Select some.table2, thing.Query1 from Query1, table2
I need to know how to make this type of Query work inside of SQL Server.
Since in Access, the Queries are saved within the database itself, and can then be used when needed.
SQL Server does not have this luxery (Or does it?)
Any help on this is greatly appreciated.