SQL Query nightmare B-(

elskan

I am having a bit of a block at the moment. Always the same when the deadline is round the next corner.

My issue:

I have two tables, products and manufacturers. Both have manufacturers_id as a key.

I am trying to display the name, price, size of the model from the products table and display the manufacturer name from manufact... table.

I am getting a bit lost in the SQL I have looked up JOIN etc but cannot quite get it ?!

$sql = "select products.model_name, products.model_description, manufacturers.manu_name from products, manufacturers where products.manufacturer_id = 4";

Any ideas to get me going in the right direction

pete_bisby

Try the following:

SELECT products.model_name, products.model_description, manufacturers.manu_name
FROM products INNER JOIN manufacturers ON products.manufacturer_id=manufacturers.manufactuer_id
WHERE products.manufacturer_id = 4

Also, try using aliases for your table names - you can shorten the query down considerably. So, the above SQL query would look like:

SELECT P.model_name, P.model_description, M.manu_name
FROM products P INNER JOIN manufacturers M ON P.manufacturer_id=M.manufactuer_id
WHERE P.manufacturer_id = 4