I have a table with 3 columns: branchId, repoId and userId. I need to find users who created branch for repo 1 or repo 2 but not for repo 3. Any help will be much appreciated.
I tried doing the following:
Try something like below.
select userId from branch where repoId in(1,2) AND userid not in(select userid from branch where repoId =3)