Hi Community
I have a user table, with a column called [Level] with two possible entries “full” or “limited”
If [Level] = “full” then you can see all records in the RESERVE table
Else If [Level] = “limited” then can see only the records, which in the column [Email] is the same as USERSETTINGS(EMAIL), in the RESERVE table
I would like some help with this syntax. How can I declare this condition?
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |