Find the value based on Comma seperated list

I have a Table - 1 with a path (comma seperated value) of everyone who reports to someone Table 1 Column1 - value A,B,C example : A,B,C where A and B reports to C   Another Table , Table 2 which ...