Advertisement
DimitarVasilev

Untitled

Jul 12th, 2017
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.33 KB | None | 0 0
  1. --1.1 How many reports the user with username “UNIBOX” can access?
  2.  
  3. SELECT COUNT(1)
  4. FROM
  5. (SELECT DISTINCT m.module_id
  6. FROM module m, module_category mc, gu_module gm, gui_users gu
  7. WHERE gu.gui_user_id=gm.gui_user_id
  8. AND gm.module_id=m.module_id
  9. AND m.module_category_id=mc.module_category_id
  10. AND gu.gui_user_id=101054);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement