I have the following between these two tables, id column and case column
Left Table Right Table
| id1 | case#1 | | case#1 | id1 |
| id2 | case#1 | | case#1 | id3 |
| id3 | case#2 | | case#2 | id1 |
As you can see case#1
is not assigned to id2
on the right table, therefore I would like to pull the (id2, case#1)
record from the left table.