Seaching across 2 tables

[jacquesy]

I have two tables which make up the full names of my product, i.e. A manufacrurer table containing manufactuer_name and a model table containing model_name.

so the full name of a product would be "manufactuer_name model_name" (e.g. Fujifilm Finepix).

I need to perform a simple search using match where the user enters a value, the problem is I also need to concatinate these two vales at the same time to perform this earch on the whole name.

This is where I get stuck, can anybody help me?

Thanks.😃 😃 😃

[barand]

I assume the product table has a manufacturer code, in which case

select m.manufacturer_name , p.model_name, <..plus any other data u want..> from manufacturer m inner join product p on p.manu_code = m.manu_code where m.manufacturer_name = '$manName' and p.model_name='$prodName'

Does this help?