Such as
Table 1
Name (primary key)...
Zhang SAN
Li si
Fifty
The horse six

Table 2:
Name disciplines through
Zhang SAN is A
Zhang SAN is B
Cathy is C
D fifty and no
E li si is

Check the following results:
Name by number (the number of "yes" in table 2)
Zhang SAN 2
Li si 1
Fifty and 1
The horse 6 0