语法顺序
执行顺序
关于内连接和 inner join on
SELECT A.value, B.value
FROM tablea AS A INNER JOIN tableb AS B
ON A.key = B.key;
可以不明确使用 INNER JOIN,在where中进行等值连接
SELECT A.value, B.value
FROM tablea AS A, tableb AS B
WHERE A.key = B.key;
关于sql中between的用法
WHERE column_name
BETWEEN value1 AND value2
value1和value2可以是数值、文本或日期,取的值介于value1和value2之间,包括value1 和 value2。