INNER JOIN, Products and Categories

Question

I have the following Practice:

You are working at a supermarket and you need to arrange products by categories. You are given the following tables: Each product has a category.
Write a query to output all products with their categories (productname-price-categoryname) in one table.

I have tried the folllowing:

Select products.ID, categories.ID
From products
INNER JOIN categories
ON products.ID = categories.ID;

Select products.productname,products.price,categories.categoryname
From products
INNER JOIN categories
ON products = categories;

SELECT Products.categoryid, Categories.categoryname
FROM Products
INNER JOIN Categories ON Categories.categoryid=Categories.categoryname;

SELECT Products.categoryid, Categories.categoryname
FROM Products
INNER JOIN Categories
ON Categories.categoryid=Products.categoryname;

SELECT Products.categoryname, Categories.categoryname,
FROM Products
INNER JOIN Categories
ON Products.categoryid=Products.categoryname;

No luck. Any suggestions?

Answer 1

select products.productname, products.price,categories.categoryname from products,categories where products.categoryid=categories.id;

or

SELECT products.productname, products.price, categories.categoryname FROM products INNER JOIN categories ON products.categoryid=categories.id;

this will work

Answer 2

The correct answer is:

SELECT products.productname, products.price, categories.categoryname
FROM products
INNER JOIN categories
ON products.categoryid=categories.id;

Answer 3

Both work:

select productname,price,categoryname from
products inner join categories
on products.categoryid = categories.id;

-------OR------ this one work too:

select productname, price, categoryname from
products as p,categories as c
where p.categoryid=c.id;

Answer 4

This is what I am currently seeing.

Input
No Input
Your Output
productname,price,categoryname
Expected Output
productname,price,categoryname
Apple,800,Fruit
Potato,400,Vegetable
Orange,900,Fruit
Tomato,450,Vegetable
OrangeJuice,250,Juice
TomatoJuice,350,Juice

Answer 5

SELECT products.productname, products.price, categories.categoryname
FROM products INNER JOIN categories ON products.categoryid=categories.id;

Answer 6

select productname,price,categoryname from
products inner join categories
on products.categoryid = categories.id;

this one is working

Answer 7

SELECT products.productname,products.price,categories.categoryname
FROM products INNER JOIN categories ON products.categoryid = categories.id

Answer 8

SELECT products.productname, products.price, categories.categoryname
FROM products INNER JOIN categories
ON products.categoryid=categories.id

Answer 9

SELECT products.productname,products.price,
categories.categoryname
FROM products INNER JOIN categories
on products.categoryid = categories.id

This will work

Answer 10

You are working with the tables Products and Orders. Each product has an id, while the Orders table has a referencing product_id.

Drag & drop to select the name from the products table and the corresponding price from the orders table.