似乎您的要求是联接
members表,但您正在联接
telephone表。只是改变他们的顺序。
SELECt `m`.*, `t`.* FROM `memebers` AS `m` JOIN `telephone` AS `t` JOIN `memeberFunctions` AS `mf` ON `m`.`id` = `mf`.`memeber` AND `mf`.`function` = 32 JOIN `mitgliedTelephone` AS `mt` ON `m`.`id` = `mt`.`memeber`;
希望这对您有所帮助。谢谢!!



