mysql - Sql Result IN a Query -

dont blame database design.i not database architect. 1 has use in current situation

i hope understandable. have 3 tables containing following data no foreign key relationship b/w them:

groups groupid    groupname 1          admin  2          editor 3          subscriber  preveleges groupid    roles 1          1,2 2          2,3 3          1  roles roleid    roletitle 1         add 2         edit 

query:

select roles  groups left join preveleges on (groups.groupid=preveleges.groupid) 

returns specific result i.e roles.

problem: wanted show roletitle instead of roles in above query. confused how relate table roles query , returns required result

i know feasible coding want in sql.any suggestion appreciated.

select g.groupname,        group_concat(r.roletitle                      order find_in_set(r.roleid, p.roles))          roletitles groups g   left join preveleges p      on g.groupid = p.groupid   left join roles r     on find_in_set(r.roleid, p.roles) group g.groupname ; 

tested at: sql-fiddle