Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
@pala_jagadeesh can you elaborate
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)