立即学习:https://edu.csdn.net/course/play/27328/370703?utm_source=blogtoedu
select A.*
from student A where a.id in
(select B.code
from subject B where B.job = '政治');
select A.*
from student A where a.id in
(select B.code
from subject B where B.code =A.id);
select A.*
from student A where
EXISTS
(select *
from subject B where B.code = A.id);