By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
7 rows affected
ENTITY | CAT1 | EMAILCAT1 | CAT2 | EMAILCAT2 |
---|---|---|---|---|
A | Mary;Steve | maryD@gmail.com;steveR@gmail.com | Jacob | jacobB@gmail.com |
B | Alex;John | AlexT@gmail.com;JohnP@gmail.com | Sally;Andrew | sallyD@gmail.com;AndrewV@gmail.com |