- 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;
- 課課通計算機原理
- 現代測控系統典型應用實例
- Mastering Spark for Data Science
- Dreamweaver CS3網頁制作融會貫通
- 計算機應用基礎·基礎模塊
- 空間機器人遙操作系統及控制
- PIC單片機C語言非常入門與視頻演練
- 樂高創意機器人教程(中級 下冊 10~16歲) (青少年iCAN+創新創意實踐指導叢書)
- The Python Workshop
- Azure PowerShell Quick Start Guide
- Citrix? XenDesktop? 7 Cookbook
- Python文本分析
- 計算機應用基礎實訓·職業模塊
- Deep Learning Essentials
- 計算機辦公應用培訓教程