Code:I have 2 tables APPS and ACCESS
APPS
------------------
APP_ID
1
2
3
ACCESS
------------------
APP_ID USER_ID
1 bosco123
If a record exists for an app in the ACCESS table then it only can be
displayed to that user. If no records exist for an app in the ACCESS
table then it is free to be shown to anyone.
Use Case
bosco123 logs in. He should see all apps (1,2 and 3). someguy456 logs in
and he should only see 2 and 3.
Seeking help with this query. It seems simple but I have been struggling.
Thanks