Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1.2 Make a list of all reports the user with username “MFrankart” has access to. The list should
- --display the internal report name, the translated title and description of the report to the
- --language of the user.
- SELECT m.name, s.str_value, m.DESCRIPTION
- FROM module m, module_category mc, gu_module gm, gui_users gu,str s
- WHERE gu.gui_user_id=gm.gui_user_id
- AND gm.module_id=m.module_id
- AND m.module_category_id=mc.module_category_id
- AND m.str_id=s.str_id
- AND gu.LANGUAGE=s.LANGUAGE
- AND gu.gui_user_id=101452;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement