string sql = "select * from (select nvl(a.user_name,'暫無'),b.sub_plate_id from mdsets_bbs_users a,mdsets_bbs_plate_boss b where a.user_id=b.user_id) where sub_plate_id=12我向實現 當user_name在數據庫中為空時 顯示 “暫無”沒用過這個 不知道怎麼回事
--你这样应该没错啊 select * from (select nvl(a.user_name,'暫無'),b.sub_plate_id from mdsets_bbs_users a,mdsets_bbs_plate_boss b where a.user_id=b.user_id) where sub_plate_id=12
select * from
(select nvl(a.user_name,'暫無'),b.sub_plate_id
from mdsets_bbs_users a,mdsets_bbs_plate_boss b
where a.user_id=b.user_id)
where sub_plate_id=12