默认情况下,如果使用MySQL,MySQL将返回所有表的所有列
*。您将需要在查询中显式输入列名称,以所需的方式检索它们。使用查询,如下所示:
SELECt A.HEAD_name, A.Family_Size, A.Gender, A.ID_Number, A.DOB, B.Supervisor_ID, B.Supervisor_Name, B.Supervisor_Number, C.Center_ID, C.LocationFROM Family AJOIN SUPERVISOR B on ( A.Supervisor_ID = B.Supervisor_ID)JOIN CENTER C on (B.Center_ID = C.Center_ID);



