ORACLE查询条件查询所有数据，并根据查询条件返回不同USERNAME,nvl2用法

select tu.*,
tb.id,
tb.biddername,
nvl2(tu.username, tu.enterprisename, tb.biddername) as username,
tb.price,
to_char(tb.pricedate, ‘yyyy-mm-dd hh24:mi:ss’) pricedate
from trans_bidder tb
left join trans_user tu on tu.username = tb.biddername
and tu.username = ‘hd’ --left join on and
order by tb.pricedate desc