一上午就写了一条SQL语句
select rewarduser.Reward_UserID,
(
case rewarduser.Reward_SectionID when 0 then ‘暂无分配部门’ else
(
select section.Reward_SectionName
from reward_section as section
where rewarduser.Reward_SectionID=section.Reward_SectionID
)
end
) as section,
rewarduser.Rewa