By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
WITH
[order_statements]
AS
(
SELECT
*
FROM
(
VALUES
(1, 1),
(2, 1),
(3, NULL),
(4, 1),
(4, 2)
)
AS [t1]
(
[OrderId],
[OrderStatementId]
)
),
[statments]
AS
(
SELECT
*
FROM
(
VALUES
(1),
(2)
)
AS [t1]
(
[StatementId]
)
| OrderId | StatementId | OrderStatementId |
|---|---|---|
| 1 | 1 | 1 |
| 1 | 2 | null |
| 2 | 1 | 1 |
| 2 | 2 | null |
| 3 | 1 | null |
| 3 | 2 | null |
| 4 | 1 | 1 |
| 4 | 2 | 2 |