Vue

MySql INNER JOIN And x

INNER JOIN (內部連接)

INNER JOIN (內部連接) 為等值連接，必需指定等值連接的條件，而查詢結果只會返回符合連接條件的資料。

1
2
3
4
5
6
7
8
9
10
SELECT table_column1, table_column2...
FROM table_name1
INNER JOIN table_name2 
ON table_name1.column_name=table_name2.column_name;
//or
SELECT table_column1, table_column2...
FROM table_name1
INNER JOIN table_name2 
USING (column_name);

Example

1
2
3
4
SELECT customers.C_Id,customers.Name,customers.Address,customers.Phone,customers.Salary,orders.Order_No,orders.Product,orders.Product,orders.Quantity
FROM `customers`
INNER JOIN `orders`
ON customers.C_Id =orders.C_Id

NATURAL JOIN

1
2
3
SELECT table_column1, table_column2...
FROM table_name1
NATURAL JOIN table_name2;

Example

1
SELECT customers.C_Id,customers.Name,customers.Address,customers.Phone,customers.Salary,orders.Order_No,orders.Product,orders.Product,orders.Quantity FROM `customers` NATURAL JOIN `orders`;