SQL Server提供了多种JOIN机制,在联机丛书FROM (Transact-SQL)中列举了四种JOIN操作.
1.INNER JOIN(交集)
INNER JOIN在数学上是指两个集合的交集,数学符号∩。如下图所示,图中红色部分则为INNER JOIN的结果。
例如:
{1, 2} ∩ {1, 2} = {1, 2}.
{1, 2} ∩ {2, 3} = {2}.
{2, 5,8} ∩ {3, 7,9} = ∅(空集).
在SQL Server数据库中,两表或者多表之间的交集关系通过INNER JOIN来实现两个或者多个表之间的相同部分。
USE AdventureWorks2012;
GO
SET STATISTICS IO ON;
-- INNER JOIN
PRINT '--INNER JOIN--'
SELECT
[PSN].*
,[PWD].*
FROM [Person].[Person] AS [PSN]
INNER JOIN [Person].[Password] AS [PWD]
ON [PWD].[BusinessEntityID] = [PSN].[BusinessEntityID]
WHERE [PSN].[BusinessEntityID] =