SQL Exercises: Display the item name, price, and company name of all the products
SQL JOINS: Exercise-22 with Solution
Write a SQL query to display the item name, price, and company name of all the products.
Sample table: company_mast
Sample table: item_mast
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;
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a SQL query to display all the data from the item_mast, including all the data for each item's producer company.
Next: Write a SQL query to display the average price of items of each company, showing the name of the company.
What is the difficulty level of this exercise?