Kind of confused as to how to develop the following query.
I have a forum where each forum may either have a projectID attached to it or NULL.
Each user has a list of projectIDs that they have access to.
Very simply, what I would like to do is return a list of forums that the user has access to (which includes the NULL projectID forums)
So if I have forums: A, B, and C. which have corresponding projects: 1, NULL, and 2, respectively.
Bob has access to project 1.
I would like to retrieve forums: A and B.
Help in this situation would be nice.
I have a forum where each forum may either have a projectID attached to it or NULL.
Each user has a list of projectIDs that they have access to.
Very simply, what I would like to do is return a list of forums that the user has access to (which includes the NULL projectID forums)
So if I have forums: A, B, and C. which have corresponding projects: 1, NULL, and 2, respectively.
Bob has access to project 1.
I would like to retrieve forums: A and B.
Help in this situation would be nice.