select '审核标志' = ( CASE approve_flag  WHEN '1' then '已审核'    WHEN '0' then '未审核'    ELSE '其它'   END ), sheet_no, branch_no,(select branch_name from t_bd_branch_info where branch_no=t_pm_sheet_master.branch_no) 仓库名称, supcust_no,(select sup_name from t_bd_supcust_info where supcust_no = t_pm_sheet_master.supcust_no) as 供应商名称,sheet_amt, oper_id, oper_date,relate_sheet_no as 关联单号, '备注'=other1  from t_pm_sheet_master  order by oper_date desc