select products.*, manufactors.*
from products, manufactors
where products.manufactor_id=manufactors.manufactor_id
and ( products.product_description like 'param%' or
manufactors.manufactor_description like 'param%');
regards
Jason Davis ?:
>I have 2 tables, one is products and one is manu
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 (us
