sql - mysql inner joins query -

sql - mysql inner joins query -

having problems next inner joins query on products table -->>

select products.prod_id, products.prod_name, products.price, suppliers.company_name, customers.phone, products inner bring together suppliers on suppliers.supp_id = suppliers.supp_id;

you joining on suppliers.supp_id = suppliers.supp_id;

both suppliers table... want attribute product table. like:

products.supp_id = suppliers.supp_id;

which result in next query:

select products.prod_id, products.prod_name, products.price, suppliers.company_name, customers.phone products inner bring together suppliers on products.supp_id = suppliers.supp_id;

mysql sql inner-join