sql语句如何将三张表所有要的属性显示

Question

SQL大神指教指教，谢谢！
表一:XS
Sno Sname Sex birthday Pid class department (表一属性)

表二:CJ
Sno Courseno Score (表二属性)

表三：KC
Courseno Coursename credit (表三属性)

要求："用相关查询语句"查询选修课程号为”xx“ 的学生的相关信息

Answer 1

select XS.Sno, Sname,Sex, birthday, Pid, class, department,
KC.Courseno, Coursename, credit, Score
from XS
left join CJ on CJ.Sno = XS.Sno
left join KC on KC.Courseno = CJ.Courseno