SQL 表合并,内连,左连,右连

表合并

union ALL --重复的值 

union --不重复的值

          select mat_code,desc_str,'F' AS TYPE from fg 
union ALL select mat_code,desc_str,'S' AS TYPE from sfg 
union ALL select mat_code,desc_str,'P' AS TYPE from parts

备注,字段和顺序都相似才可以,字段个数必须相同
另外，UNION 结果集中的列名总是等于 UNION 中第一个 SELECT 语句中的列名。


错误:
select mat_code,desc_str  from fg 
union  select mat_code,desc_str,'S' AS TYPE from sfg 
union select mat_code,desc_str,'P' AS TYPE from parts

-- 内连,两边匹配的返回
SELECT * FROM fg INNER JOIN sfg ON fg.ID = sfg.ID

--左边,左边匹配和左右匹配的返回
SELECT * FROM fg left  JOIN  sfg ON fg.ID = sfg.ID

--左边,右边匹配和左右匹配的返回
SELECT * FROM fg RIGHT JOIN  sfg ON fg.ID = sfg.ID