By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| CatA | CatB |
|---|---|
| XCY | XCY |
| XC | XC |
| KJ | null |
| KG | KG |
| KFD | null |
Warning: Null value is eliminated by an aggregate or other SET operation.
8 rows affected
| CatA | CatB |
|---|---|
| XCY | XCY |
| XC | XC |
| KJ | null |
| KG | KG |
| KFD | null |
Warning: Null value is eliminated by an aggregate or other SET operation.