sql - Heroku postgres 错误尝试制作数据剪辑

Question

我试图通过 heroku postgres dataclips 提取一些数据，我想从多个表中提取数据：

SELECT participants_team.short_name,results_teamscore.points,results_teamscore.score,draw_debateteam.side
FROM results_teamscore JOIN participants_team JOIN draw_debateteam
ON participants_team.id=draw_debateteam.id 

但是每次我在句子中添加一个条件时，AND它都会停止工作：

SELECT participants_team.short_name,results_teamscore.points,results_teamscore.score,draw_debateteam.side
FROM results_teamscore JOIN participants_team JOIN draw_debateteam
ON participants_team.id=draw_debateteam.id AND participants_team.id=results_teamscore.team_id

并给出这个信息：

Dataclip Error
ERROR:  syntax error at end of input
LINE 5: 
        ^

我不知道会是什么：c

标签： sqlpostgresqlheroku