主题：[求助]如何达到这样的效果，让下单表中的数据自动生成到订单表中

Select '门框' as 名称, ([宽] - [宽减]) as 宽,([高] - [高减]) as 高,数量 from{下单} where 宽 >0 UNION 

Select '门扇' as 名称, ([宽] - [宽减]-110) as 宽,([高] - [高减]-60) as 高,数量 from{下单} where 宽 >0 UNION 

Select '锁' as 名称, Null as 宽,Null as 高,数量 from{下单} where 宽 >0 UNION 

Select '合页' as 名称, Null  as 宽, Null as 高,数量*3 as  数量 from{下单} where 宽 >0