I was wondering if you could tell me if this is even possible or if it can be done another way???
So i have a database with 6 tables all the databases have the same columns except for the tables name ahead of the generic headers pub_name, Hotel_name, restaurant_Name etc.
Estentially i want to take all the values that meet the search criteria out of the 6 tables so if i want all the restaurants hotels and pubs that are in ennis can i do it??