By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
PARTY_NAME | Bill To Number | Customer Bill To Name | Customer Email Address | DUMMY |
---|---|---|---|---|
Party 1 | 1006746009 | CUSTOM PRODUCTS | lorne@testemail.net | A |
Party 1 | 1006746009 | CUSTOM PRODUCTS | newton@testemail.net | B |
Party 2 | 1006746010 | PAINT COMPANY | APAL@testemail.com | A |
Party 2 | 1006746010 | PAINT COMPANY | tgliwell@testemail.com | B |
Party 3 | 1006746011 | ADVANCED MATERIALS | invo@testemail.com | A |
Party 4 | 1006746012 | ADVANCED PRODUCTS | accpayable@testemail.com | A |