- Learn T-SQL Querying
- Pedro Lopes Pam Lahoud
- 171字
- 2021-06-24 14:38:09
INNER JOIN
Inner joins compare the rows from two tables based on conditions specified in the query. Typically, this type of join would be used to intersect rows that have the same value in a specific column or set of columns. The only rows that would be returned are the ones that have matching rows in both tables, as represented in black in the following diagram:

For example, the AdventureWorks sample database has a Product table that contains the ProductID and Name columns and a ProductInventory table that contains the ProductID and Quantity columns. To write a query that returns the product name and the quantity together, an inner join can be used to combine rows from the Product table with rows from the ProductInventory table based on matching values in the ProductID column. In this case, only products that have rows in both tables will be returned. The query would look like the following:
SELECT Name AS ProductName, Quantity
FROM Production.Product
INNER JOIN Production.ProductInventory ON Product.ProductID = ProductInventory.ProductID;
- 現代測控系統典型應用實例
- Go Machine Learning Projects
- 協作機器人技術及應用
- Hands-On Machine Learning on Google Cloud Platform
- Maya 2012從入門到精通
- 城市道路交通主動控制技術
- 統計策略搜索強化學習方法及應用
- Kubernetes for Serverless Applications
- 菜鳥起飛系統安裝與重裝
- 單片機原理實用教程
- 網絡安全概論
- 中老年人學電腦與上網
- Wireshark Revealed:Essential Skills for IT Professionals
- Hands-On Artificial Intelligence for Beginners
- Ubuntu 9 Linux應用基礎