1.join語句
Sql join語句用來合并兩個或多個表中的記錄。ANSI标準SQL語句中有四種JOIN：INNER，OUTER，LEFTER，RIGHT，一個表或視圖也可以可以和它自身做JOIN操作。下面舉例說明。下面所舉的例子使用的表有Employee和Department，在這兩個表中Department.DepartmentID是主鍵，Employee.DepartmentID是外鍵。
圖1—Employee表
| LastName | DepartmentID | Country | EmployeeID |
| John | NULL | Germany | 306 |
| Jones | 33 | Australia | 124 |
| Rafferty | 31 | 123 | |
| Robinson | 34 | United States | 201 |
| Smith | 305 |
圖2—Department表
| DepartmentName | |
| Sales | |
| Engineering | |
| Clerical | |
| 35 | Marketing |
下面是建表和資料語句：
代碼
USE [AppressFinancial]
GO
/****** Object: Table [dbo].[department] Script Date: 08/11/2010 15:18:33 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[department](
[DepartmentID] [int] NULL,
[DepartmentName] [varchar](25) NULL,
UNIQUE NONCLUSTERED
(
[DepartmentID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET ANSI_PADDING OFF
作者：
Tyler Ning出處：
http://www.cnblogs.com/tylerdonet/本文版權歸作者和部落格園共有，歡迎轉載，但未經作者同意必須保留此段聲明，且在文章頁面明顯位置給出原文連接配接，如有問題，可以通過以下郵箱位址
[email protected]聯系我，非常感謝。