Simple Mysql Query :)

[tazgalsinh]

I have 2 tables makes,products

makes

makeid primary
name

products

prod_id primary key
makeid
model_no
description
RRP

in the products i have set it so it refers to a make number in the make tables.

How do i do a query so i can say display all products with a make ID of 5 etc.?

[theeper]

SELECT * FROM products,makes WHERE makes.makeid=products.makeid && makes.makeid = '5'

[tazgalsinh]

works fine, cheers 🙂