select tb.*,b.Building_Name, t.Teacher_Name from building b left join tb on b.Building_ID = TB_BuildingID left join teacher t on tb.TB_TeacherID = t.Teacher_ID
MYsql查询三表显示三表需求是这样的:根据TB表查询TB表对应的Teacher_Name和Building_Name语句如下(原理:左连接套左连接)select tb.*,b.Building_Name, t.Teacher_Name from building b left join tb on b.Building_ID = TB_BuildingID left join teac...