select

t.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 出纳2

from 

nis_billhead@btlink t

left join sys_user@btlink t1

on t.create_by = t1.login_name

left join sys_user@btlink t2

on t.update_by = t2.login_name

--left join BIS_EXC t3

--on t.id = t3.CBS_BILL_ID