SQL Server 2022

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

CREATE TABLE Customers 
(
    CustomerID      int         NOT NULL    PRIMARY KEY
,   CustomerName    varchar(10) NOT NULL
);

CREATE TABLE Orders 
(
    OrderID         int         NOT NULL    PRIMARY KEY
,   CustomerID      int         NOT NULL
,   OrderDate       date        NOT NULL
);
INSERT INTO Customers 
(   CustomerID
,   CustomerName
) 
    VALUES
        (1, 'Alice')
    ,   (2, 'Jeff')
    ,   (3, 'Bob')
  ;
3 rows affected

INSERT INTO Orders 
(   OrderID
,   CustomerID
,   OrderDate
) 
    VALUES
        (111, 1, '2026-03-11') -- Alice
    ,   (112, 1, '2026-03-12') -- Alice
    ,   (113, 2, '2026-03-12') -- Jeff
    ,   (114, 1, '2026-03-13') -- Alice
    ,   (115, 2, '2026-03-13') -- Jeff
    ;
5 rows affected

SELECT  *
FROM    Customers;


CustomerID
CustomerName


1
Alice

2
Jeff

3
Bob


SELECT  *
FROM    Orders;


OrderID
CustomerID
OrderDate


111
1
2026-03-11

112
1
2026-03-12

113
2
2026-03-12

114
1
2026-03-13

115
2
2026-03-13


SELECT  *
FROM    Customers c
LEFT OUTER JOIN
        Orders o
    ON  c.CustomerID = o.CustomerID
    ;


CustomerID
CustomerName
OrderID
CustomerID
OrderDate


1
Alice
111
1
2026-03-11

1
Alice
112
1
2026-03-12

1
Alice
114
1
2026-03-13

2
Jeff
113
2
2026-03-12

2
Jeff
115
2
2026-03-13

3
Bob
null
null
null


SELECT  *
FROM    Orders o
RIGHT OUTER JOIN
        Customers c
    ON  c.CustomerID = o.CustomerID
    ;


OrderID
CustomerID
OrderDate
CustomerID
CustomerName


111
1
2026-03-11
1
Alice

112
1
2026-03-12
1
Alice

114
1
2026-03-13
1
Alice

113
2
2026-03-12
2
Jeff

115
2
2026-03-13
2
Jeff

null
null
null
3
Bob


/*
Same result, but columns changed order.
Easily fixable, but you have to be aware it needs fixing.
*/

OrderID	CustomerID	OrderDate
111	1	2026-03-11
112	1	2026-03-12
113	2	2026-03-12
114	1	2026-03-13
115	2	2026-03-13

CustomerID	CustomerName	OrderID	CustomerID	OrderDate
1	Alice	111	1	2026-03-11
1	Alice	112	1	2026-03-12
1	Alice	114	1	2026-03-13
2	Jeff	113	2	2026-03-12
2	Jeff	115	2	2026-03-13
3	Bob	null	null	null