something like - Select * from RoomMemberTable where RoomMemberId "ONLY IN" ('RM1','RM3') My table structure -
RoomId RoomMemberId R1 RM1 R1 RM2 R1 RM3 R2 Rm1 R2 RM2 R3 RM1 R3 RM3
I need to get rows which contains only these room members. Here i don't need such entries where any other member except RM1 and RM3 presents.
Aucun commentaire:
Enregistrer un commentaire