一.内连接查询
交叉连接(笛卡尔积)sql语句如下:
select *from line CROSS JOIN vehicle 等价于:select *from line,vehicle
内连接查询语法如下:
SELECT fiedlist FROM table1 [INNER] JOIN table2 ON table1.column1=table2.column2[where condition]
自然连接语法如下:
SELECT fieldlist FROM table1 NATURAL JOIN table2[where condition]
二.多表查询
三表连接查询语法如下:
SELECT fieldlist FROM table JOIN table2 ON table1.column1=table2.column2_1 JOIN table3 on
table2.column2_2=table3.column3[where condition]
两表连接查询语法如下:
SELECT fieldlist FROM table1,table2
WHERE table1.column1=column2[and 其他条件]