So I am trying to apply my newly-acquired SQL skillz to this application I am writing, and my SQL knowledge is not cutting it for me. I have a query which has 3 nested subqueries within it. When I run it from inside Access, it returns the data I want. If I pull any one of the three subqueries and use ASP to run it individually, it returns the data I want. But when I use ASP to run the whole query, I gets nothin. Nada. Even the non-subquery values return null. I can't figure it out.