SQL Server Query subquery

[NYCProgrammer]

Hi, how do you include the results of a query in another query? I know that you refer to a table by typing dbo.Tablename.Fieldname, but how about another query? Where do you store the query?

[Brandoe85]

Do you have an example of what you're trying to do? Maybe it's a sub query, maybe it's a union, maybe a join...