Hi! I was wondering lately how to solve this problem: I want to extract data from many tables that depend on table names from one particular field. People say that a picture is sometimes better than 1000 words. Please, take a short look at the image attached. The query must be dynamic because the number of tables is constantly changing(now it's about 20). I've found some information about dynamic SQL but I am not certain that it is the easiest way to solve this problem. Any hints would be appreciated Thank you!