Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --trial conversion
- SELECT PRF_USER.USERNAME, PRF_PROFILE.KEY_ID, PRF_FUNC.DESCRIPTION , PRF_MENU.DESCRIPTION , PRF_MENU.POSITION
- FROM (
- (
- (
- SELECT * FROM PRF_USER
- INNER JOIN PRF_REL_USER_PROFILE ON PRF_REL_USER_PROFILE.USER_ID = PRF_USER.USER_ID
- INNER JOIN PRF_PROFILE ON PRF_REL_USER_PROFILE.PROFILE_ID = PRF_PROFILE.PROFILE_ID
- INNER JOIN PRF_REL_FUNCTION_PROFILE ON PRF_REL_FUNCTION_PROFILE.PROFILE_ID = PRF_PROFILE.PROFILE_ID
- )
- INNER JOIN PRF_FUNC
- ON (PRF_REL_FUNCTION_PROFILE.FUNCTION_ID = PRF_FUNC.FUNCTION_ID)
- )
- INNER JOIN PRF_REL_FUNCTION_MENU
- ON (PRF_REL_FUNCTION_MENU.FUNCTION_ID = PRF_FUNC.FUNCTION_ID)
- )
- INNER JOIN PRF_MENU
- ON (PRF_MENU.MENU_ID = PRF_REL_FUNCTION_MENU.MENU_ID)
- WHERE PRF_PROFILE.PROFILE_ID = 'Admin'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement