求一简单sql语句

[blue_snow]

a表
id
userid
name
age
四个字段
b表
userid
course
grade
三个字段
其中a表和b表通过userid相关联
要求选出id=10 的 name course grade 的值

[myserver]

select a.name,b.course,b.grade from a ,b where a.id =10 and a.userid=b.userid

[Ouyangyifeiczy]

select a.id,a.name,b.course,b.grade from a inner join b on a.userid=b.userid where a.id=10

[ToUpdate]

select a.name,b.course,b.grade from a join b on a.userID-b.userID and a.ID=10

[mymmsc]

select a.name,b.course,b.grade from a ,b where a.id =10 and a.userid=b.userid