表合并
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