MySql 命令错误

Question

我在sql中有两个表:

client
id   first
1    david
2    jenna
3    ben

rating
id  clientid userid rating ratetext         date
1   1        3      4      Very good        12/4/2012
2   3        6      3      Simple bla bla   5/3/2013

我想获得一个userid的所有评分所以我尝试类似的东西:

SELECT rating,ratetext,date,first FROM rating r 
INNER JOIN client c ON r.userid = 3;

但是我总是得到那些我不需要得到的行。知道我的命令有什么问题吗？

Answer 1

SELECT rating, ratetext, date, first 
FROM   rating r INNER JOIN client c 
ON     r.clientid = c.id
WHERE  r.userid = 3;