By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
(No column name) |
---|
Microsoft SQL Server 2019 (RTM-CU3) (KB4538853) - 15.0.4023.6 (X64) Mar 4 2020 00:59:26 Copyright (C) 2019 Microsoft Corporation Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor) |
11 rows affected
material | Attachment |
---|---|
101 | 1 |
102 | 2 |
201 | 4 |
202 | 4 |
301 | 2 |
parent | child |
---|---|
101 | 201 |
101 | 202 |
101 | 204 |
101 | 205 |
102 | 301 |
102 | 302 |
parent | child | attachment |
---|---|---|
101 | 201 | 4 |
101 | 202 | 4 |
101 | 204 | null |
101 | 205 | null |
102 | 301 | 2 |
102 | 302 | null |