select A.ID as AID,A.AI,A.AII,B.ID as BID,B.BI,B.BIII from A inner join B on A.ID=B.ID
select xxxx from b inner join a on a.id = b.id
SELECT *FROM [Sheet2].外语成绩, [002].数学成绩WHERE 外语成绩=[数学成绩];