Creating Nested Queries

Question:
My question is with regards to VB’s ability to handle complexSQL. I have the application I am developing set up in the followingway: I copy the SQL created into the recordsource of a data control and then refresh the data control. The problem I am having is with SQL statements inside of SQL statements:

Example:

SELECT Work_Request_Number FROM Work_Request_File WHERE Work_Request_Number = (SELECT Work_Request_Number FROM[Work_Request/Problem_List] WHERE Problem_Number = (SELECT Problem_Number from Application_Error_Codes WHEREApplication_Error_Code = “ABC”))

I have tried changing the quotes to single quotes, tried justone SQL statement inside another, etc. and SOMETIMES I get it to come up but most of the time I get an error code of either-3070 or 3000. I have looked in the VB manual and Error code 3000 is considered an “UNKNOWN ERROR”.

Answer:
Try changing the equal sign to the word “IN”, so the query looks like “SELECT fields FROM table WHERE ID IN (SELECT ID FROM TABLE WHERE OTHERID IN (SELECT OTHERID FROM TABLE2 WHERE OTHERID2 = 5)). That SQL code is ANSI standard, but it may be a little different for Access. Check the docs for the IN keyword.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

6 Tips for Setting Up a Decentralized Exchange

6 Tips for Setting Up a Decentralized Exchange

There’s no doubt that cryptocurrency is a complex and divisive topic in the modern financial landscape. There are those who are convinced that it’s nothing more than a bubble, but both who are well-informed are able to see the ways in which cryptocurrency can help them both build their fortune

user experience with someone on their phone

5 Ways to Improve Your Customers’ User Experience

They say you can’t judge a book by its cover, but just because they say that doesn’t mean it’s true. Consider how often you choose one sort of product over another just because it appeals to you. Then think about how often you’ve stopped using something because, simply put, it

How to Manage Your Finances after Buying a Home

How to Manage Your Finances after Buying a Home

Buying a home is a milestone in the journey of life – it’s one way to invest your money and create lasting memories. Now you know everything about a home purchase, home mortgage, and what is a conventional 97 loan but do you know what’s next after you sign the

Windows Logging is one of the vital aspects of any Windows system administration. However, it is mostly overlooked until the system develops a problem. This is because logs contain important information needed to troubleshoot and resolve system issues.

The Fundamentals of Windows Logging

Windows Logging is one of the vital aspects of any Windows system administration. However, it is mostly overlooked until the system develops a problem. This is because logs contain important information needed to troubleshoot and resolve system issues. Without it, tech experts might find it difficult to track a computer’s

Interstitial Ads: Best Practices for Successful Campaigns

Interstitial Ads: Best Practices for Successful Campaigns

Interstitial Ads: Best Practices for Successful Campaigns Interstitial ads are full-screen advertisements that appear to grasp the attention of on-site prospects, creating opportunities for brands seeking effective ways to communicate their proposition of value. With such an attention-grabbing format and high-impact visuals, it’s no wonder why interstitial advertising is proving