table employees:
id | name  | idE
 1 | name1 | 1
 2 | name2 | 2
 3 | name3 | 3

table email:
id | idE | email
 1 | 1   | e1@email.com
 2 | 1   | e2@email.com
 3 | 2   | e@email2.com
 4 | 3   | e@email3.com

select e.id, e.name, m.email from employees as e inner join email as m on p.idE = m.idE

id | name  | email
 1 | name1 | e1@email.com
 1 | name1 | e2@email.com
 2 | name2 | e@email2.com
 3 | name3 | e@email3.com

select * from (select a, b from T where a > b) as Z

select * from ( select group_concat(a) as a_list from T ) as Z
where a_list like '%Henry%'