SQL Server 2019 (Linux)

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    CustomerName NVARCHAR(50),
    Email NVARCHAR(100)
);

INSERT INTO Customers (CustomerID, CustomerName, Email)
VALUES 
    (1, 'John Doe', 'john.doe@example.com'),
    (2, 'Jane Smith', 'jane.smith@example.com'),
    (3, 'Michael Johnson', 'michael.johnson@example.com'),
    (4, 'Emily Brown', 'emily.brown@example.com'); -- Customer without any order

CREATE TABLE Orders (
    OrderID INT PRIMARY KEY,
    CustomerID INT,
    OrderDate DATETIME,
    TotalAmount DECIMAL(10, 2)
);

INSERT INTO Orders (OrderID, CustomerID, OrderDate, TotalAmount)
VALUES 
    (101, 1, '2023-08-06 10:00:00', 100.00),
    (102, 2, '2023-08-06 11:30:00', 50.00),
    (103, 1, '2023-08-06 12:15:00', 75.00),
    (104, 3, '2023-08-06 14:20:00', 200.00);
8 rows affected

SELECT *
FROM Customers


CustomerID
CustomerName
Email


1
John Doe
john.doe@example.com

2
Jane Smith
jane.smith@example.com

3
Michael Johnson
michael.johnson@example.com

4
Emily Brown
emily.brown@example.com


SELECT *
FROM Orders


OrderID
CustomerID
OrderDate
TotalAmount


101
1
2023-08-06 10:00:00.000
100.00

102
2
2023-08-06 11:30:00.000
50.00

103
1
2023-08-06 12:15:00.000
75.00

104
3
2023-08-06 14:20:00.000
200.00


SELECT Customers.CustomerID
	,Customers.CustomerName
	,Orders.OrderID
	,Orders.OrderDate
	,Orders.TotalAmount
FROM Customers
INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID;


CustomerID
CustomerName
OrderID
OrderDate
TotalAmount


1
John Doe
101
2023-08-06 10:00:00.000
100.00

2
Jane Smith
102
2023-08-06 11:30:00.000
50.00

1
John Doe
103
2023-08-06 12:15:00.000
75.00

3
Michael Johnson
104
2023-08-06 14:20:00.000
200.00

CustomerID	CustomerName	Email
1	John Doe	john.doe@example.com
2	Jane Smith	jane.smith@example.com
3	Michael Johnson	michael.johnson@example.com
4	Emily Brown	emily.brown@example.com

OrderID	CustomerID	OrderDate	TotalAmount
101	1	2023-08-06 10:00:00.000	100.00
102	2	2023-08-06 11:30:00.000	50.00
103	1	2023-08-06 12:15:00.000	75.00
104	3	2023-08-06 14:20:00.000	200.00