Search multiple tables query

[robert475]

Hi

I have an access database that i would like to search. Its for a search engine where the user will type in a search term and the program (in asp) will query the database.

I am struggling to construct the query as not all of the tables are related.

The tables are constructed as follows:

Product Pictures
ProductCode
HiResPath

Products
Productcode
Datasheetfilename

News
newsStory

Promo
promoStory

subcategories
subcategoryName

Is there a way to write a query that can search these required tables and fields?

Any help would be most appreciated.

[DaveMaxwell]

You can use UNION ALL

(note: this is a bad example since these would probably be joined instead, but you get the idea)

SELECT ProductCode FROM Product_Pictures WHERE ProductCode LIKE '*A*'
UNION ALL
SELECT ProductCode FROM Products WHERE ProductCode LIKE '*A*'