You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
/*Write a SQL query to display the item name, price, and company name of all the products.*/
|
|
SELECT item_mast.pro_name, pro_price, company_mast.com_name
|
|
FROM item_mast
|
|
INNER JOIN company_mast
|
|
ON item_mast.pro_com = company_mast.com_id; |