Matching with all record except one record

[pala_jagadeesh]

Hi ,

I have a table1 with two columns persons,limit1

table 2 has column limit2

Perons from limit1 will not talk with same row of limit2 , ie jack belongs to limit1 (ABC)will not talk with Limit2 (CVV)only, otherwise he can talk with any remaining persons in limit2

Table1

Persons	limit1	limit2
Jack	ABC	CVV
paul	BCA	CNN
stephen	DCA	KLL
anni	CNN	CMM
stev	CVV	CKK

I want output like below

eg:- Group1 has member  jack;paul;stephen belongs to ABC;BCA;DCA    so there is no danger

        Group2 has member  anni;stev;paul;stephen belongs to CNN;CVV;BCA    so there is danger    here, because paul(BCA) was not talk with anni(CNN).

Group	members	Limits	Danger
1	jack;paul;stephen	ABC;BCA;DCA	No
2	anni;stev;paul	CNN;CVV;BCA	Yes
3	anni;stev	CVV;CNN	No
4	jack;anni;stev	ABC;CNN;CVV	Yes
5	stephen,stev	DCA;CVV	No

[Taoufiq_Zarra]

@pala_jagadeesh  can you elaborate

[pala_jagadeesh]

@Taoufiq_Zarra 

hi two table are there

persons from table1 jack belongs to limit1  of ABC  he cannot talk with limit2 of CVV, but he can talk with limit2 of CNN,KLL,CMM,CKK and limit1 of BCA,DCA,CNN

table1 paul belongs to limit1  of BCA  he cannot talk with limit2 of CNN, but he can talk with limit2 of CVV,KLL,CMM,CKK and limit1 of ABC,DCA,CVV

as like all persons

 Group2 has member  anni;stev;paul;stephen belongs to CNN;CVV;BCA    so there is danger    here, because paul(BCA) was not talk with anni(CNN).

 anni is in that group meeting member, she can participate with them , but paul can't talk with anni(CNN)