title: Query all tables in a db and return all items that meet query
body: <p>I will have several tables in a sql db for a web site. We are selling jewelry and we have the tables set up by type: bracelets, ear drops, chains, pendents you get the idea. The items come in different types of metals and stones. Every table has the same columns. From the menu you can chose chains and you will get all the chains, from the sub menu you can chose 18,14 ct white or yellow gold, silver or base. I have this working fine. Now we want to set up a menu where a person can chose all the items that are 18 ct yellow gold or 14 ct white gold or silver and get all the items that are made with that choice of metal. This should be easy something like FROM *table(where it would search all the tables in a db) and return the items. Am I on the correct path or not even in the same solar system. Thanks Jim </p>