两表连接查询:两个表查询的sql语句[朗读]

一、用连接查询:select*fromstudentinnerjoinscoreoncno=2andgrade>=90select*fromstudentleftouterjoinscoreoncno=2andgrade>=90select*fromstudentrightouterjoinscoreoncno=2andgrade>=90二、用子查询:select*fromstudentwheresnoin(selectsnofromscorewherecno=2andgrade>90)。