SQL SERVER常用操作（二）

--返回左右表共同存在的匹配项
SELECT * FROM dbo.Websites INNER JOIN dbo.Zhaocl ON dbo.Websites.name = dbo.Zhaocl.NAME

--即使右表中没有匹配也返回左表的所有项
SELECT * FROM dbo.Websites LEFT JOIN dbo.Zhaocl ON dbo.Websites.name = dbo.Zhaocl.NAME

--即使左表中没有匹配也返回右表的所有项
SELECT * FROM dbo.Websites RIGHT JOIN dbo.Zhaocl ON dbo.Websites.name = dbo.Zhaocl.NAME

--只要有一项匹配就返回左右表的所有项
SELECT * FROM dbo.Websites FULL JOIN dbo.Zhaocl ON dbo.Websites.name = dbo.Zhaocl.NAME

--合并两个结果集（条件：字段数、类型、顺序）
SELECT name FROM dbo.Websites UNION SELECT name FROM dbo.Zhaocl

--复制表
SELECT *INTO zhaocl_bk FROM dbo.Zhaocl			--整个表
SELECT name INTO zhaocl_name FROM dbo.Zhaocl	--部分数据
SELECT a.NAME,b.url FROM dbo.Zhaocl a,dbo.Websites b --多个表数据到一个表

--查询到的数据插入到表中
INSERT INTO dbo.Zhaocl (NAME) SELECT name FROM dbo.Websites WHERE country = 'china'