左连接语法结构如下:
SELECT * FROM table1 LEFT OUTER JOIN table2 ON table1.a=table2.b
对选中的记录进行左连接:
SELECT * FROM (SELECT * FROM table1 WHERE table1.a="**") temp LEFT OUTER JOIN table2 ON temp.a=table2.b
左连接语法结构如下:
SELECT * FROM table1 LEFT OUTER JOIN table2 ON table1.a=table2.b
对选中的记录进行左连接:
SELECT * FROM (SELECT * FROM table1 WHERE table1.a="**") temp LEFT OUTER JOIN table2 ON temp.a=table2.b