hello Martina

so far query working fine but duplicate record is still in query output.

Query Out Put:
Company_Code Name Email
001 Chung, Kristina abc@xyz.com;asdfg@gmail.com;
001 Lawrence, Neal abc@xyz.com;asdfg@gmail.com;

002 Gallagher, Marian maza@gmail.com;mazahir.naya@gmail.com;
002 Steele, Alex maza@gmail.com;mazahir.naya@gmail.com;

003 Hawkins, Stephanie rohit@gmail.com;mprint@pixel.com;
003 Middleton, Tim rohit@gmail.com;mprint@pixel.com;

004 Frame, Mark shanty@kuwait.com;

Thank You.
Best Regards,
Mazahir