SELECT COUNT(*) FROM table_X JOIN table_y ON (table_x.respondent = table_y.respondent)