Advertisement
Guest User

Untitled

a guest
May 26th, 2015
207
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.78 KB | None | 0 0
  1. --trial conversion
  2. SELECT PRF_USER.USERNAME, PRF_PROFILE.KEY_ID, PRF_FUNC.DESCRIPTION , PRF_MENU.DESCRIPTION , PRF_MENU.POSITION
  3.     FROM (     
  4.             (
  5.                 (
  6.                     SELECT * FROM PRF_USER
  7.                     INNER JOIN PRF_REL_USER_PROFILE ON PRF_REL_USER_PROFILE.USER_ID = PRF_USER.USER_ID
  8.                     INNER JOIN PRF_PROFILE ON PRF_REL_USER_PROFILE.PROFILE_ID = PRF_PROFILE.PROFILE_ID
  9.                     INNER JOIN PRF_REL_FUNCTION_PROFILE ON PRF_REL_FUNCTION_PROFILE.PROFILE_ID = PRF_PROFILE.PROFILE_ID
  10.                 )
  11.                 INNER JOIN PRF_FUNC
  12.                 ON (PRF_REL_FUNCTION_PROFILE.FUNCTION_ID = PRF_FUNC.FUNCTION_ID)
  13.             )
  14.             INNER JOIN PRF_REL_FUNCTION_MENU
  15.             ON (PRF_REL_FUNCTION_MENU.FUNCTION_ID = PRF_FUNC.FUNCTION_ID)
  16.         )
  17.     INNER JOIN PRF_MENU
  18.     ON (PRF_MENU.MENU_ID = PRF_REL_FUNCTION_MENU.MENU_ID)
  19.     WHERE PRF_PROFILE.PROFILE_ID = 'Admin'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement