[AccessD] Nested Sub Querys

Hey John
No I am talking about nested subquerys where
You can do the original query on a join for example and  do your 
calculations
Then drill down with other subsequent subquerys to produce your final 
results
Pretty cool.


jwcolby wrote:

> Are you talking about
>
> WHERE PK in (SELECT PK FROM SomeOtherSet)
>
> kind of thing?  I am using that a ton in SQL Server.  It turns 
> non-updateable queries (joined to something else) into updateable 
> queries.
>
> John W. Colby
> www.ColbyConsulting.com
>
> On 3/8/2011 11:09 AM, Tony Septav wrote:
>
>> Hey All
>> As Dan said OMG how much don't I know.
>> When fooling around with SQL Server I found you could next multiple 
>> subquerys in the pass- through
>> SQL string. I tried the same logic with Access and sure enough it 
>> works. And "Duh" did some research
>> and it has been there all along. Sure speeds things up when you are 
>> dealing with very large tables
>> of data.
>