对于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 ;