在MySQL中使用where和内部联接

在MySQL中使用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

子句必须在语句的末尾