SELECt `locations`.`name` FROM `locations`INNER JOIN `school_locations` ON `locations`.`id` = `school_locations`.`location_id`INNER JOIN `schools` ON `school_locations`.`school_id` = `schools_id` WHERe `type` = 'coun';
该
WHERe子句必须在语句的末尾
SELECt `locations`.`name` FROM `locations`INNER JOIN `school_locations` ON `locations`.`id` = `school_locations`.`location_id`INNER JOIN `schools` ON `school_locations`.`school_id` = `schools_id` WHERe `type` = 'coun';
该
WHERe子句必须在语句的末尾
名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
