Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --1.1 How many reports the user with username “UNIBOX” can access?
- SELECT COUNT(1)
- FROM
- (SELECT DISTINCT m.module_id
- FROM module m, module_category mc, gu_module gm, gui_users gu
- 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 gu.gui_user_id=101054);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement