Mindbox-task-sql

CREATE TABLE Products (
    ProductID INT PRIMARY KEY,
    ProductName VARCHAR(50)
);
CREATE TABLE Categories (
    CategoryID INT PRIMARY KEY,
    CategoryName VARCHAR(50)
);
CREATE TABLE ProductCategories (
    ProductID INT,
    CategoryID INT,
    PRIMARY KEY (ProductID, CategoryID),
    FOREIGN KEY (ProductID) REFERENCES Products(ProductID),
    FOREIGN KEY (CategoryID) REFERENCES Categories(CategoryID)
);


INSERT INTO Products (ProductID, ProductName)
VALUES
    (1, 'Яблоко'),
    (2, 'Банан'),
    (3, 'Морковь'),
    (4, 'Молоко'),
    (5, 'Хлеб');
INSERT INTO Categories (CategoryID, CategoryName)
VALUES
    (1, 'Фрукты'),
    (2, 'Овощи'),
    (3, 'Молочные продукты');
INSERT INTO ProductCategories (ProductID, CategoryID)
VALUES
    (1, 1),
    (2, 1),
    (3, 2),
    (4, 3);



SELECT p.ProductName, ISNULL(c.CategoryName, '') AS CategoryName
FROM Products p
LEFT JOIN ProductCategories pc ON p.ProductID = pc.ProductID
LEFT JOIN Categories c ON pc.CategoryID = c.CategoryID;