如何用mysql连接两个表？

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

---

想要改进此问题吗？添加详细信息并通过

闭合 2年前。

Answer 1

也许使用以下查询

select s.*,g.grade from students s 
left join grades g on s.marks between min_mark and max_mark

Answer 2

实际上分数和等级之间存在关系..所以加入是合适的

Select id,name,marks,grade
    from student
    join grades on marks between min_mark and max_mark

Answer 3

有一种关系，但不是平等的。
您也可以在min_mark和max_mark 之间使用，但是您需要检查MySQL版本是否支持它。

SELECT
  s.ID,
  s.Name,
  s.Marks,
  g.grade
FROM
  Students s,
  Marks s
WHERE
  s.Marks >= g.Min_Mark
AND
  s.Marks <= g.max_Mark;