|
select distinct S_HALFYEARTRAIN.id, S_HALFYEARTRAIN.p_year,S_HALFYEARTRAIN.p_halfyear,S_HALFYEARTRAIN.fj,F_DEALER.dealer_name," +
" S_HALFYEARTRAIN.shuom,S_HALFYEARTRAIN.up_person,S_HALFYEARTRAIN.up_date,S_HALFYEARTRAIN.audit,S_HALFYEARTRAIN.audit_date," +
" S_HALFYEARTRAIN.audit_yj,S_HALFYEARTRAIN.score,S_HALFYEARTRAIN.status,xtm08.xtyhxm from xtm08,F_DEALER, S_HALFYEARTRAIN,V_USER_SHOP " +
" where S_HALFYEARTRAIN.status='未审批' and xtyhdm=S_HALFYEARTRAIN.up_person and S_HALFYEARTRAIN.up_person=V_USER_SHOP.user_id " +
" and F_DEALER.dealer_id=S_HALFYEARTRAIN.dealer_id and V_USER_SHOP.shop_id in (select shop_id from V_USER_SHOP where V_USER_SHOP.user_id='"+index.xtyhdm+"') order by up_date
|