最后一段代码更正为如下比较合适: SELECT s.id sid, s.class_id scid, s.name, s.gender, s.score, c.id cid, c.name cname FROM students s, classes c WHERE s.gender = 'M' AND c.id = s.class_id;
Sign in to make a reply
长宁特产
最后一段代码更正为如下比较合适: SELECT s.id sid, s.class_id scid, s.name, s.gender, s.score, c.id cid, c.name cname FROM students s, classes c WHERE s.gender = 'M' AND c.id = s.class_id;