Ver originalSELECT p.mbs_nomb, p.mbs_apell FROM principal p INNER JOIN (SELECT a1_mbs_id a_mbs_id FROM area1UNIONSELECT a2_mbs_id FROM area2UNIONSELECT a3_mbs_id FROM area3)t1 ON p.id = t1.a_mbs_id