1.查询两表唯一记录:
select*from(
selecta.订单号,count(*)as合并数from(
selectorder_codeas'订单号'frome_orderawherea.create_time>date('2016-12-01')anda.create_timeunionall
select订单号fromorder_status)agroupbya.订单号)bwhere合并数=1
CASEWHENorderinfo.ORDER_TYPE=1THEN'有线路下单'
WHENorderinfo.ORDER_TYPE=2THEN'无线路下单'
wh