Advertisement
DimitarVasilev

Untitled

Jul 12th, 2017
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. --1.3 Make the previous query to be working when for various usernames. I might ask you to
  2. --display the same list of reports for different usernames and it should work for all of them.
  3.  
  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=&userid;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement