MySQL中内连接与左连接的基本语法如下:
SELECT t1.field1,t1.field2,t1.field3,
...
t2.field1,t2.field2,t2.field3,
...
FROM table_name1 AS t1
INNER|LEFT JOIN table_name2 AS t2
ON t1.field = t2.field
示例:
SELECT t1.*
t2.python,t2.mysql
FROM student AS t1
LEFT JOIN score AS t2
ON t1.id = t2.id
WHERE mysql>90;