71PQ43fA

1CREATE TABLE IF NOT EXISTS `categories` (
2  `id` INT(11) NOT NULL AUTO_INCREMENT,
3  `name` VARCHAR(50) NOT NULL,
4  PRIMARY KEY (`id`)
5)
6 
7INSERT INTO `categories` (`id`, `name`) VALUES
8    (1, 'Овощи'),
9    (2, 'Фрукты');
10 
11CREATE TABLE IF NOT EXISTS `products` (
12  `id` INT(11) NOT NULL AUTO_INCREMENT,
13  `name` VARCHAR(50) NOT NULL,
14  `category_id` INT(11) NOT NULL,
15  PRIMARY KEY (`id`)
16)
17 
18INSERT INTO `products` (`id`, `name`, `category_id`) VALUES
19    (1, 'Тыква', 1),
20    (2, 'Баклажан', 1),
21    (3, 'Бананы', 2),
22    (4, 'Персики', 2);
23 
24SELECT products.name, categories.name FROM `products` LEFT JOIN `categories` ON products.category_id = categories.id;