- update t_porg_commission_discount d set d.status=2 where exists (select id from t_plvs_order o where o.settlement_status < 1 and o.commission_rate_id > 0 and d.status=1 and d.time_date=o.time_date and d.travel_agency_id=o.travel_agency_id and d.store_id=o.store_id and d.sale_type=o.sale_type)
- --该片段来自于http://www.codesnippet.cn/detail/0707201614816.html
来源: http://www.codesnippet.cn/detail/0707201614816.html