Comparacion entre dos tablas con campos diferentes

[jurena]

Los que aparecen en reg_form_a y no en reg_form_b

Código MySQL:

SELECT *
FROM reg_form_a
LEFT JOIN reg_form_b ON reg_form_a.email = reg_form_b.email WHERE reg_form_b.email IS NULL
 

Los que aparecen en reg_form_b y no en reg_form_a

Código MySQL:

SELECT *
FROM reg_form_b
LEFT JOIN reg_form_a ON reg_form_b.email = reg_form_a.email WHERE reg_form_a.email IS NULL