CategoryProductTable

CREATE TABLE Products (
Id INT NOT NULL,
Name TEXT,
PRIMARY KEY (Id)
);

INSERT INTO Products VALUES
(1, 'Хлеб'),
(2, 'Молоко'),
(3, 'Пиво'),
(4, 'Арбуз');

CREATE TABLE Categories (
Id INT NOT NULL,
Name TEXT,
PRIMARY KEY (Id)
);

INSERT INTO Categories
VALUES
(1, 'Хлебобулочные'),
(2, 'Молочные изделия'),
(3, 'Алкоголь');

CREATE TABLE Products_Categories (

INT ProductId,
INT CategoryId,

FOREIGN KEY (ProductId) REFERENCES Products(Id),
FOREIGN KEY (CategoryId) REFERENCES Categories(Id),

PRIMARY KEY (ProductId, CategoryId)
);

INSERT INTO Products_Categories
VALUES
(1, 1),
(2, 2),
(3, 3);

SELECT Product."Name", Categories."Name"
FROM Products
LEFT JOIN Products_Categories
ON Products.Id = Products_Categories.ProductId
LEFT JOIN Categories
ON Products_Categories.CategoryId = Categories.Id;