Advertisement
Guest User

Untitled

a guest
May 26th, 2015
200
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.50 KB | None | 0 0
  1. SELECT username, prf_groups.keyid, prf_functionality.description , prf_menu.description , prf_menu.POSITION FROM (((prf_users
  2. NATURAL JOIN prf_rel_users_group NATURAL JOIN prf_groups
  3. NATURAL JOIN prf_rel_funcs_group)
  4. INNER JOIN prf_functionality ON (prf_rel_funcs_group.func_id = prf_functionality.func_id ))
  5. INNER JOIN prf_rel_functs_menu ON (prf_rel_functs_menu.func_id = prf_functionality.func_id))
  6. INNER JOIN prf_menu ON (prf_menu.menu_id = prf_rel_functs_menu.menu_id)
  7. WHERE prf_groups.keyid = 'CMS';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement