SqlServer 表连接教程(问题解析)

--CREATE TABLE Customers
CREATE TABLE Customers
(
  CustID VARCHAR(50) NOT NULL, --顾客ID
  CustName VARCHAR(50),--顾客姓名
  CustCompany VARCHAR(50) --顾客公司
)

--Initial Customers

INSERT INTO Customers VALUES('SXN-DD-01','赵武','A')
INSERT INTO Customers VALUES('SXN-DD-02','刘杨','B')
INSERT INTO Customers VALUES('SXN-DD-03','张永为','C')
INSERT INTO Customers VALUES('SXN-DD-04','李龙飞','D')
INSERT INTO Customers VALUES('SXN-FF-01','邓华','E')
INSERT INTO Customers VALUES('SXN-HH-01','张涛明','F')