conditional matching

[pala_jagadeesh]

Hi I have two tables

table1

Group1	region1
aaa	india
bbb	china
ccc	japan
ddd	srilanka
eee	usa
fff	germany

table2

Group1	region2
aaa	china
bbb	usa
ccc	germany
ddd	usa
eee	germany
fff	belgium

here group1 aaa persons belongs to  india not talk with china,  

                         bbb persons belongs to china not talk with usa,  likewise all

i want output like below

group	meeting	condition
aaa;bbb;ccc	india;china;japan	danger
ddd;eee;fff	srilanka;usa;germany	danger

in the above group three pesons in one meeting aaa;bbb;ccc these persons belongs to india;china;japan,

already we mentioned aaa persons belongs to  india not talk with china,  but they are involved in one meeting , so condtion shows danger,

[kaushiknsolanki]

It is difficult to understand what you want. What are these 2 tables and from where the group and meeting field will come. Share some sample data and explain in detail.