数据查询加强篇

一.多表连接

• 内连接

  
  image.png

• 左外连接

  
  image.png

• 右外连接
  

  image.png
  image.png
  SELECT *
  FROM
  (
  (
  (
  students st
  JOIN scores sc
  ON st.sno = sc.sno
  )
  JOIN courses co
  ON sc.cno = co.cno
  )
  JOIN teachers te
  ON te.tno = co.tno
  );

image.png