【Lin Ether】評論

「Inner join」通常稱為「內部結合」，它可以應付大部份的結合查詢需求，內部結合有兩種寫法，差異在把結合條件設定在「WHERE」子句或「FROM」子句中。

【yakevinya不放手直】評論

https://www.1keydata.com/tw/sql/sqlin.htmlStore_Information 表格Store_NameSalesTxn_DateLos Angeles150005-Jan-1999San Diego25007-Jan-1999San Francisco30008-Jan-1999Boston70008-Jan-1999我們就鍵入，SELECT * FROM Store_Information WHERE Store_Name IN ('Los Angeles', 'San Diego');

【william】評論

INNER JOINThe INNER JOIN command returns rows that have matching values in both tables.The following SQL selects all orders with customer information:ExampleSELECT Orders.OrderID, Customers.CustomerNameFROM OrdersINNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;