Member Avatar for joseph.lyons.754

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
  • 210 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Webville312
Member Avatar for cereal

Have you tried union all?

(select * from table1 where field1 = 'value to search') union all (select * from table2 where field1 = 'value to search') union all (select * from table3) order by field1;

Read this: http://dev.mysql.com/doc/refman/5.0/en/union.html

Edited by cereal
Member Avatar for imBaCodes

It is pissoble ..
Also TRy this
I always look here. When i had some probelm on query.

Member Avatar for Webville312

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.