0

Hey guys,

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??

Thanks

4
Contributors
4
Replies
42
Views
4 Years
Discussion Span
Last Post by Webville312
0

Yes, it is very possible. You can do a Union, left or right joins, depending on what you want to achieve.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.