小弟我用到的sql语句

ea_student_paper.sql
es_adminuser.sql
es_menu.sql
es_paper_cat.sql









select m.name as sname, t.realname as tname,g.name as pname,studentscore,studentobjectivescore,studentsubjectivescore,studentanswer,markstate,marktime,examtime,laststate,spid from es_member m,es_student_paper s,es_goods  g ,es_adminuser t where m.member_id = s.sid and s.pid = g.goods_id and t.userid = s.markadminid  order by pid desc






SELECT a.*,s.* FROM es_adminuser a INNER JOIN es_user_role s on a.userid = s.userid where s.roleid =3; 


SELECT COUNT(Customer) AS CustomerNilsen FROM Orders
WHERE Customer='Carter'


方法giveTeacherPaper

INSERT  INTO  es_student_paper (sid,pid,examtime,studentscore,studentobjectivescore,studentsubjectivescore,studentanswer,markadminid) VALUES (37,2,2,2,2,2,2,2);









select m.name as sname, t.realname as tname,e.name as pname,c.name as cname,e.exam_id,e.cat_id,studentscore,studentobjectivescore,studentsubjectivescore,studentanswer,markstate,marktime,s.examtime,laststate,spid from es_member m,es_student_paper s,es_exam e,es_adminuser t,es_goods_cat c where m.member_id = s.sid and s.pid = e.exam_id and t.userid = s.markadminid and c.cat_id = e.cat_id  order by pid desc

查找判卷教师
select userid from es_adminuser where papernum=(select min(a.papernum) FROM es_adminuser a INNER JOIN es_user_role s on a.userid = s.userid where s.roleid =3 order by s.userid) limit 1

select DISTINCT e.name ,e.examTime,cs.cat_id,e.exam_id ,sp.spid,sp.totaltimes,sp.usetimes from es_goods g 
left join es_order_items i on g.goods_id = i.goods_id  
left join es_order o on i.order_id=o.order_id  
left join es_goods_cat c on g.cat_id = c.cat_id  
left join es_goods_cat s on c.parent_id = s.cat_id  
left join es_goods_cat cs on s.parent_id = cs.cat_id 
left join es_goods_type t on t.type_id =g.type_id   
left join es_exam_goods eg on g.goods_id = eg.goods_id 
left join es_exam e on e.exam_id = eg.exam_id 
left join es_student_paper sp on sp.pid = e.exam_id 
where o.member_id=1 and sp.sid=o.member_id and o.pay_status=1 and t.type_id = 4