--返回左右表共同存在的匹配项
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'