select t1.tnoticeid,
       t1.ftype,
       t1.ftitle,
       t1.fsummary,
       t1.checkdate,
       t1.fcontent,
       t1.createby,
       t1.createdate,
       t1.fstatus,
       t1.fissecret,
       t1.changeby,
       t1.changedate,
       t1.fisontop,
       t1.fbegdate,
       t1.fenddate,t2.description as fcolor,
       t1.checkby
from DSBCRM..tnotice t1
left join DSBCRM..ttypedetail t2 on t1.siteid=t2.siteid and t1.ftype=t2.fvalue and t2.ftype='¹«¸æ°å¿é'
where t1.siteid = $siteid$ and t1.tnoticeid=$tnoticeid$