select student.name from student join regu on student.name = regu.name; select student.name from student join (select name from regu) as r on student.name = r.name;