selectt.bursar_bill_no,t.status,t.is_payed,'' VOUCHER_STAT,t.create_date,t.payer_acc_name,t.payer_acc,t.payer_bank,t.PAY_MONEY,t.payee_acc_name,t.payee_acc,t.payee_bank,to_char(t.CREATE_DATE,'yyyy-MM-dd') 支付日期,t1.username 出纳1,t2.username 出纳2from nis_billhead@btlink tleft join sys_user@btlink t1on t.create_by = t1.login_nameleft join sys_user@btlink t2on t.update_by = t2.login_name--left join BIS_EXC t3--on t.id = t3.CBS_BILL_ID