When do you use Nested Queries VS duplicated Code
I have a question that’s of a design problem than a Code one. This is based on a complex structure. It’s really dificult to get all the important information for the question destiled here without revealing too much about the bussines and also without makeing an imposibly long post. I’ll do my best to explain everything as clear as I can. But if you think something is not clear, please let me know and I’ll try to explain it in another way.
In a table with As and Bs, select those As for which the Bs are all associated with a given list of B_criteria
Given the following table structure: