立即学习:https://edu.csdn.net/course/play/24472/291790?utm_source=blogtoedu
from stu join class where class id = 2 and stu.id%2 = 1
###join连接两个表
##stu id 为奇数
from stu join class where on class id = class.id class id = 2 and stu.id%2 = 1
##on条件过滤