sql - MySql Wrong command -


i have 2 tables in sql:

client id   first 1    david 2    jenna 3    ben  rating id  clientid userid rating ratetext         date 1   1        3      4             12/4/2012 2   3        6      3      simple bla bla   5/3/2013 

and want rating userid try like:

select rating,ratetext,date,first rating r  inner join client c on r.userid = 3; 

but rows other rows don't need get. idea wrong command?

select rating, ratetext, date, first    rating r inner join client c  on     r.clientid = c.id  r.userid = 3; 

Comments

Popular posts from this blog

monitor web browser programmatically in Android? -

Shrink a YouTube video to responsive width -

wpf - PdfWriter.GetInstance throws System.NullReferenceException -