FREE AI-Enhanced Online SQL Server Compiler

Untitled*

You must execute the code again to save those values in the database.

CREATE TABLE Categories (
    CategoryId INT PRIMARY KEY,
    CategoryName VARCHAR(100)
);

INSERT INTO Categories (CategoryId, CategoryName) VALUES 
(1, 'Electronics'),
(2, 'Clothing'),
(3, 'Groceries'),
(4, 'Furniture');

CREATE TABLE Products (
    ProductId INT PRIMARY KEY,
    ProductName VARCHAR(100),
    CategoryId INT,
    UnitPrice DECIMAL(10,2)
);

INSERT INTO Products (ProductId, ProductName, CategoryId, UnitPrice) VALUES 
(1, 'Laptop', 1, 1200.00),
(2, 'Smartphone', 1, 800.00),
(3, 'Headphones', 1, 150.00),
(4, 'T-Shirt', 2, 25.00),
(5, 'Jeans', 2, 50.00),
(6, 'Jacket', 2, 120.00),
(7, 'Milk', 3, 2.50),
(8, 'Bread', 3, 1.50),
(9, 'Cheese', 3, 5.00),
(10, 'Sofa', 4, 900.00),
(11, 'Dining Table', 4, 1500.00),
(12, 'Chair', 4, 250.00),
(13, 'Bread', NULL, 1.50),
(14, 'Cheese', 5, 5.00),
(15, 'Sofa', NULL, 900.00),
(16, 'Dining Table', 5, 1500.00),
(17, 'Chair', 6, 250.00);

--SELECT P.*
--FROM Products P
--WHERE P.CategoryId NOT IN (SELECT CategoryId FROM Categories);

SELECT t1.*
FROM Products t1
LEFT JOIN Categories t2 ON t1.CategoryId = t2.CategoryId
WHERE t2.CategoryId IS NULL;

ProductId	ProductName	CategoryId	UnitPrice
13	Bread	NULL	1.50
14	Cheese	5	5.00
15	Sofa	NULL	900.00
16	Dining Table	5	1500.00
17	Chair	6	250.00

(4 rows affected)

(17 rows affected)

(5 rows affected)