I have a table/tables that look like something like bellow and it has couple thousand of records.
ID protocol
1 10
2 10
2 12
3 11
4 11
5 10
3 12
3 10
6 11
6 12
6 13
... ...
I can easily find all the IDs that belong to either protocol 10 or protocol 11 or protocol 12... etc.
But I need to know if a certain IDs are not only into protocol 10 but also into some other protocols (in this example, 3 is also involed in protocol 12, ID 6 is in protocols 11, 12 and 13 etc),
and so on for all other ID. To be more precise, I want to obtain the ID that are not only in, let's say protocol 10, but also in other protocols and to list them all.
Thanks for your help guys.