select * from orcam INNER JOIN ccusto as a ON orcam.Ccusto = a.Ccusto INNER JOIN grupo_email b on a.Ccusto
COLLATE SQL_Latin1_General_CP1_CI_AS = b.cc INNER JOIN grupo_resp c ON b.resp = c.id  where orcam.Ccusto=0151 and anomes=201709

Ccusto | Grupo | Anomes | Ccusto | cc | resp | id | email
0151     0452    201709   0151    0151  1      1    email01@mail.com
0151     0452    201709   0151    0151  1      2    email02@mail.com

Ccusto | Grupo | Anomes | Ccusto |  cc  | email
0151     0452    201709   0151    0151   email01@mail.com;email02@mail.com