爷的眼睛闪亮
insideDotNet En_summerGarden

select
w.woType,
'NO_HIS' as dataFrom
from
workorder_complet_info w
where
w.workOrderNo = 'xxxxxx'
union all
select
w.woType,
'HIS' as dataFrom
from
workorder_complet_info_his w
where
w.workOrderNo = 'xxxxxx';

 

标红的为核心点

posted on 2022-05-12 12:33  爷的眼睛闪亮  阅读(215)  评论(0)    收藏  举报