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