Çë½ÌÒ»Ìõ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

---

лл¸÷λ