Ver originalSELECT tp.* FROM tpersonal tp LEFT JOIN (SELECT Tpersona_id FROM tregistro WHERE fecha = CURDATE())t1 ON tp.id = t1.Tpersona_idWHERE t1.Tpersona_id IS NULL