Here's the problem: the products are not all contained in one table. They CAN'T be, because different types of products require different types of specifications. So, I've got each product type in its own table. I want a SQL query that will search the PRODUCT_NAME column of all the tables for values containing the user's search term. I understand I'll need some kind of join for this, but the online resources I've looked at all seem to gloss over joins, which is surprising as they seem essential to database use.
Anyhow, here's a simplified example... if anyone can provide an example query for this scenario, I'll be able to figure it out:
1. We have 3 tables - EXTRACTS, ESSENCES, CONCENTRATES. They contain different types of info, but all of them contain a column called PRODUCT_NAME, which is a text data type.
2. I need a query which selects each record FROM ALL 3 TABLES that contains the word, say, "apple" in the PRODUCT_NAME column.
And that's it. Seems like it oughta be simple, but I just can't make it work! Any help would be great....oh, and it's an MS Access database.