Display common matched and mismatched values between three tables

[pala_jagadeesh]

Hi 

I have three table

table1

Name

sam;sam@;sam@1;sam@2

ant;ant@;ant@1

jan;jan@

george

susi

robert

josh

bob;bob@;bob@1

cat;cat@;cat@1

Table2

Name1

sam

ant

jan

hesi

yesu

paul

josh

Table3

Name2

sam

ant

jan

george

chema

robert

soba

I want output like below because only sam, ant, jan only present in three tables, remaining all are not present in three tables, some are missed in even one table also.

I want matched and nonmatched values come as like below ouput tables only

Matched

sam

ant

jan

Nonmatched

hesi

yesu

paul

josh

george

chema

robert

soba

josh

bob;bob@;bob@1

cat;cat@;cat@1

I want count on KPI as like below

Count of matched

3

Count of Nonmatched

11

[MarcoWedel]

what are the field names?

how are these tables associated?

[pala_jagadeesh]

@MarcoWedel 
please take filed names 

for table1 filed name is name

for table2 field name is name1

for table3 field name is name2