1.left join(左联接)
sql语句如下:
SELECT * FROM a
LEFT JOIN b
ON a.aID =b.bID
2.right join(右联接)
sql语句如下:
SELECT * FROM a
RIGHT JOING b
ON a.aID = b.bID
3.inner join(相等联接或内联接)
sql语句如下:
SELECT * FROM a
INNER JOIN b
ON a.aID =b.bID
等同于以下SQL句:
SELECT *
FROM a,b
WHERE a.aID = b.bID
4.distinct
作用单列,作用多列, count,因为distinct必须放在开头
select distinct name from table; --distinct必须放在开头
count是不能统计多个字段的 select count(*) from (select distinct id, name from t) AS r;
学习来源地址:https://www.jianshu.com/p/476b52ee4f1b