程序代码：

select 计划单号 as MPS计划单号,g_name as 产品名称,计划投入量 as 计划产量,开始日期 as 计划投产时间,结束日期 as 计划产出时间
from
(select a.计划单号,g_name,计划投入量,开始日期 from MPS_Ouput a,MPS_Input where a.计划单号=MPS_Input.计划单号 and  a.计划投入量<>0)t1
union
(select 结束日期 from MPS_Ouput b where b.计划产出量<>0)t2