phpmyadmin - Displaying certain records from MySQL statement -
i want display records products table
structure of products table:
structure of suppliers table:
i want display product ids, product descriptions, product prices, , supplier company name , contact phone number products , list them in descending order of price. how do using mysql?
[per edited post] need join
both table , add order price desc
in select
statement; like
select p.`prod_id`, p.`prod_name`, p.`price`, s.`company_name`, s.`phone` products p join suppliers s on p.supp_id = s.supp_id order p.`price` desc;
Comments
Post a Comment