I need to setup a query to search the same named field (called NDC)in multiple tables. Each table will have this specific field, but may also have additional, different fields. Is this possible and how do you do it?
