Access SQL

css navigation by Css3Menu.com

Nested SubQuery

I knew I could do a subquery within a query. I got this wild bug to write a sub-subquery,

I was get lots of error messages until I wrote 2 simple subqueries, printed them out, and figured how to put them together.

SELECT dbo_IApps.*, dbo_IApps.[Application Name]
FROM dbo_IApps, dbo_Sconfigs, dbo_Ssoftware
WHERE (((dbo_IApps.[Application Name])="Master Data") 
AND ((dbo_IApps.SName) In (SELECT [Machine Name] FROM dbo_SConfigs  WHERE ((dbo_SConfigs.[Machine Name]) 
In (SELECT Server FROM dbo_Ssoftware)))));

In the end, I did something else because the “Sconfigs” table has 150K rows and it was taking way to long to run.

I wrote 3 nested RecordSets that write to one text file that is pulled into Excel (and prettied up) before my customer sees it.


© 2013-2017

Updated:  04/06/2017 20:31
This page added:  07 May 2013