`slelect*from line CROSS JOIN vehicle 等價(jià)于：select*from line，vehicle

SElECT fieldlist FROM table1 【INNER】JOIN table2 ON 
table1.column1=table2.column2 【where condition】

select fieldlist FROM table1 NATURAL JOIN table2 【where condition】

SELECT fieldllist FROM table1 JOIN table2 ON 
tabke1.column1=table.column2_1 JOIN table3 on
 table2.column2_2=table.column3【where condition】

SELECT fieldlist FROM table1, table2
HERE table1.column1=table2.column2 【and其他條件】

`SELECT字段名稱FROM表名1 LEFT|RIGHT|FULL [OUTER] JOIN 表名2 ON 表名1.字段名1=表名2.字段名2`

SELECT
	v.plateNO 車牌號(hào),
	v.model 型號(hào),
	d. NAME 司機(jī)姓名,
	l.lineNo 線路號(hào),
	l.from_station 起點(diǎn)站,
	l.end_station 終點(diǎn)站
FROM
	line l,
	vehicle v,
	driver d
WHERE
	v.type = '非空調(diào)車'
AND l.lineID = v.lineID
AND d.driverID = v.driverID;

SELECT
	NAME 司機(jī)姓名,
	licenseNO 身份證,
	d.gender 性別,
	phone 電話
FROM
	vehicle v,
	driver d,
	line l
WHERE
	v.driverID = d.driverID
AND v.lineID = l.lineID
AND company = '公交二公司'
GROUP BY 

SELECT
v.plateNO 車牌號(hào),
	v.model 型號(hào),
	l.lineNo 線路號(hào),
	l.from_station 起點(diǎn)站,
	l.end_station 終點(diǎn)站
FROM
	line l,
	vehicle v
WHERE
	v.type = '非空調(diào)車'
AND l.lineID = v.lineID;

	SELECT
	d.NAME 司機(jī)姓名,
	licenseNO 身份證,
	d.gender 性別,
	phone 電話,
	v.plateNO 車牌號(hào),
	v.model 型號(hào),
	l.lineNo 線路號(hào),
	l.from_station 起點(diǎn)站,
	l.end_station 終點(diǎn)站
FROM
	vehicle v,
	driver d,
	line l
WHERE
	v.driverID = d.driverID
AND v.lineID = l.lineID
GROUP BY 司機(jī)姓名;

SELECT
	c.cName 客戶姓名,
	o.ordersDate 下單日期,
	g.goodsName 商品名,
	g.unitPrice 單價(jià),
	od.quantity 件數(shù)
FROM
	ordersdetail od,
	goods g,
	orders o,
	customer c
WHERE
	c.cName = '王傳華'
AND c.customerID = o.customerID
AND o.ordersID = od.ordersID
AND od.goodsID = g.goodsID;

SELECT
	c.cName 客戶姓名,
	o.ordersDate 下單日期,
	g.goodsName 商品名,
	g.unitPrice 單價(jià),
	od.quantity 件數(shù)
FROM
	ordersdetail od,
	goods g,
	orders o,
	customer c
WHERE
	c.cName = '王傳華'
AND c.customerID = o.customerID
AND o.ordersID = od.ordersID
AND od.goodsID = g.goodsID;

SELECT
	c.cName 客戶姓名,
	c.phone 電話,
	o.ordersID 訂單ID,
	o.ordersDate 下單時(shí)間
FROM
	 customer c
LEFT JOIN orders o on c.customerID=o.customerID;

SELECT
	c.cName 客戶姓名,
	c.phone 電話,
	o.ordersID 訂單ID,
	o.ordersDate 下單時(shí)間
FROM
	orders o
right JOIN customer c on c.customerID=o.customerID;