MYSQL joint query related problems

MYSQL federated query problem

1, Table A:

< table > < thead > < tr > < th > group ID < / th > < th > group < / th > < / tr > < thead > < tbody > < tr > < td > 1 < / td > < td > li si, Cathy, Chen six < / td > < / tr > < tr > < td > 2 < / td > < td > 2, seven money, rich, big S < / td > < / tr > < / tbody > < / table >

2, B table

< table > < thead > < tr > < th > name < / th > < th > professional < / th > < / tr > < thead > < tbody > < tr > < td > and < / td > < td > work < / td > < / tr > < tr > < td > money. < / td > < td > lending < / td > < / t Big S r > < tr > < td > < / td > < td > selling breakfast < / td > < / tr > < tr > < td > < / td > jay singing < td > < / td > < / tr > < tr > < td > jj Lin < / td > < td > wash dishes < / td > < / tr > < / tbody > < / table >

Problem:
Finds the person who exists in group 1 and has a record in b
eg:

< table > < thead > < tr > < th > name < / th > < th > professional < / th > < / tr > < thead > < tbody > < tr > < td > and < / td > < td > work < / td > < / tr > < / tbody > < / table >