请教一条Sql语句 - .NET技术 / ASP.NET

根据exam_id 得到 gg_exam_ys_XXXXXX 表信息

select student_id,score,score_type,description,
from gg_exam_ys_XXXXXX where exam_id='F64DC0A5-0B69-4B4C-865B-1D983678BA72'

然后我要根据 student_id 获取 gg_student表里的学生信息

把 gg_student 和 gg_exam_ys_XXXXXX 表信息 对应在一起

---

SQL code:

select a.*,b.* from gg_exam_ys_XXXXXX as a
join student as b
ob b.student_id =a.student_id
where a.exam_id=xxx

---

SQL code:
select e.student_id,e.score,e.score_type,e.description,s.*
from gg_exam_ys_XXXXXX as e inner join gg_student as s on s.student_id=e.student_id where e.exam_id='F64DC0A5-0B69-4B4C-865B-1D983678BA72'

---

连接....

---

多表查询
类似这样的
select c.claid , c.claname , c.clapass , t.tid , t.claid from class c, tit t where c.claid=t.claid

---

谢谢各位