表A 表B 在2个表中完全相同的字段Cselect a1.subject from A a1,B a2where a1.C=a2.C and a1.subject=a2.subject;
select subject from aintersectselect subject from b
