/* For this challenge you need to create a simple SELECT statement that will return all columns from the products table, and join to the companies table so that you can return the company name. products table schema: id name isbn company_id price companies table schema: id name You should return all product fields as well as the company name as "company_name". */ SELECT products.*, companies.name AS company_name FROM products JOIN companies ON company_id = companies.id
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter