I have 2 tables, one is products and one is manufactors.
The products table has a col. for Product_descriptions and manufactor_id
column that is a foriegn key to the manufactors table.
The manufactors table has a manfuactor_description column, for each unique
Manufactor_id.
I want to search (using like) on both tables (columns:
Products.Product_description and Manufactors.Manufactor_description).
Can anyone suggest a cross-table %Like% Query for it?
Thanks!