#2
oldfish962020-07-26 02:27
|
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