Advertisement
DimitarVasilev

Untitled

Jul 12th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.52 KB | None | 0 0
  1. --1.2 Make a list of all reports the user with username “MFrankart” has access to. The list should
  2. --display the internal report name, the translated title and description of the report to the
  3. --language of the user.
  4. SELECT m.name,  s.str_value, m.DESCRIPTION
  5. FROM module m, module_category mc, gu_module gm, gui_users gu,str s
  6. WHERE gu.gui_user_id=gm.gui_user_id
  7. AND gm.module_id=m.module_id
  8. AND m.module_category_id=mc.module_category_id
  9. AND m.str_id=s.str_id
  10. AND gu.LANGUAGE=s.LANGUAGE
  11. AND gu.gui_user_id=101452;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement