SELECT products.id, products.title, products.category_id, categories.title AS category FROM products JOIN categories ON products.category_id = categories.id;

SELECT products.*, categories.title AS category FROM products JOIN categories ON products.category_id = categories.id;

SELECT p.*, c.title AS category FROM products p JOIN categories c ON p.category_id = c.id;

SELECT p.*, c.title AS category FROM products p LEFT JOIN categories c ON p.category_id = c.id;

SELECT p.*, c.title AS category FROM products p RIGHT JOIN categories c ON p.category_id = c.id;

SELECT city.Name, country.Name AS country_name, city.Population FROM city
	LEFT JOIN country ON country.Code = city.CountryCode;
	
SELECT city.Name, country.Name AS country_name, city.Population FROM city
	RIGHT JOIN country ON country.Code = city.CountryCode;

SELECT city.Name, country.Name AS country_name, city.Population FROM city
	JOIN country ON country.Code = city.CountryCode;
	