When i run your query against my database i have got this as output.

Input

EID = 3

Output:

MID EID E.Name

11A

12AA

13AAA

14AAAA

31C

32CC

33CCC

But, i cannot able to under stand how this solution will fit for my suituation.Can you explain bit more to me.

Thanks