By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| PART NUMBER | PLANT | VENDOR CODE | SUPPLIER NAME | POSTING DATE | Supplier |
|---|---|---|---|---|---|
| 123 | 1001 | 1 | VEND1 | 20220304 | (2) VEND2, (1) VEND1 |
| 123 | 1001 | 2 | VEND2 | 20220611 | (2) VEND2, (1) VEND1 |