display results from two tables

[I Love Doing Websites]

Hello,

I have two tables, PRODUCTS and MANUFACTURERS
I can show the results of all the products passing a querystring in the url stating the product category. not a problem.

but now, I do I show the results from both tables: PRODUCTS and MANUFACTURERS where the query string should be the manufacturer name.

the two tables have this foreign key:

PRODUCTS >> manufacturerid
MANUFACTURERS>> manufacturerid

other related fields of the tables:

PRODUCTS>> prodimage, price, description
MANUFACTURERS>> manufacturer name

and the query string should be the manufacturer name, which is not hte manufacturer id.

Mauricio
??

[Newsgroup_User]

Look up information on "INNER JOINS"

Select P.manufacturerid, P.price, P.description, M.manufacturerid
From PRODUCTS P INNER JOIN M.manufacturerid ON P.manufacturerid =
M.manufacturerid