SQL LEFT JOIN 语法
SELECT column_name(s)
FROM table1
LEFT JOIN table2
ON table1.column_name=table2.column_name;
实例:
这里是 table1
这是table2
SELECT table1.name, table2.count, table.date
FROM table1
LEFT JOIN table2
ON table1.id= table2.site_id
ORDER BY table2.count DESC;
table1 返回所有值
table2 即使没有相对应的匹配值