select * from student
where exists
(select id from scores s where s.id=s.id);
selext *from student st
(select id from score s where s.id=st.id
select * from student
where exists
(select id from scores s where s.id=s.id);
selext *from student st
(select id from score s where s.id=st.id