I have three tables such as
User

+--+------+|Id|Name |+--+------+|1 |Ram |+--+------+|2 |Rama |+--+------+|3 |Leesa |+--+------+|4 |Kelvin|+--+------+Role

+--+-------+|Id|Name |+--+-------+|1 |Admin |+--+-------+|2 |FA |+--+-------+|3 |Testing|+--+-------+|4 |IT |+--+-------+User Role

+--+-------+-------+|Id|User Id|Role Id|+--+-------+-------+|1 |1 |1 |+--+-------+-------+|2 |1 |2 |+--+-------+-------+|3 |2 |3 |+--+-------+-------+|4 |2 |1 |+--+-------+-------+|5 |3 |2 |+--+-------+-------+|6 |3 |3 |+--+-------+-------+|7 |4 |4 |+--+-------+-------+|8 |4 |2 |+--+-------+-------+From these 3 tables I want output like that

+--+---------+--------+|Id|User Name|Roles |+--+---------+--------+|1 |Ram |Admin,FA|+--+---------+--------+

Check Solution