SELECt `quotes`.`id` as `ID`, `quote`.`quote` as `quote`, SUM(`votes`.`vote`) AS `vote`FROM `quotes` LEFT JOIN `votes` ON `quotes`.`id` = `votes`.`quote`GROUP BY `quotes`.`id`
应该做到的。
假设
id列是主键(它们对于每个记录都是唯一的)。

SELECt `quotes`.`id` as `ID`, `quote`.`quote` as `quote`, SUM(`votes`.`vote`) AS `vote`FROM `quotes` LEFT JOIN `votes` ON `quotes`.`id` = `votes`.`quote`GROUP BY `quotes`.`id`
应该做到的。
假设
id列是主键(它们对于每个记录都是唯一的)。