Ĭ


select activity_member.id,memberid,membername,'<font color=#999999>'+industry+','+works+','+birth_address+','+sex+'</font>' as info,signdate,case status when 2 then 'ѱ' when 1 then 'Ѳμ' when 0 then '<font color=red>δμ</font>' end as status from activity_member,member,industry where memberid=member.id and indu_id=industry.id and activityid=@activityid