Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT username, prf_groups.keyid, prf_functionality.description , prf_menu.description , prf_menu.POSITION FROM (((prf_users
- NATURAL JOIN prf_rel_users_group NATURAL JOIN prf_groups
- NATURAL JOIN prf_rel_funcs_group)
- INNER JOIN prf_functionality ON (prf_rel_funcs_group.func_id = prf_functionality.func_id ))
- INNER JOIN prf_rel_functs_menu ON (prf_rel_functs_menu.func_id = prf_functionality.func_id))
- INNER JOIN prf_menu ON (prf_menu.menu_id = prf_rel_functs_menu.menu_id)
- WHERE prf_groups.keyid = 'CMS';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement