对于student学生表（sno,sname,sex,sage,sdept）以及选课表sc(sno,cno,grade)，请问”查询刘佳同学得选课”，其SQL语句为？（ ）

A、select sc.* from student,sc where student.sno=sc.sno and sname=’刘佳’;
B、select sc.* from student inner join sc on student.sno=sc.sno and sname=’刘佳’;
C、select sc.* from student,sc where sname=’刘佳’;
D、select sc.* from student,sc where student.sno=sc.sno ;