Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL Server
Expertise: Beginner
Oct 29, 1999

Nested Selects

Question:
In Microsoft Access you can use a query as the source for a select in a second query. Additionally, you can use two queries as the source by utilizing an inner join. What Access does is fire off the two queries and use the result set as the data source for the third. Since the two source queries are made up of their own select statements, can I somehow nest those queries into a third to produce the same data set?

Answer:
Yes, these are called virtual tables in SQL.

DevX Pro
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date