select t1.tworkid,t1.fdate,t2.fstorename,t2.fmarket,t1.fdays from twork t1
left join tstore t2 on t1.siteid=t2.siteid and t1.tagentsid=t2.tagentsid and t1.tstoreid=t2.tstoreid
where t1.fworktype='±ê×¼' and t1.siteid=$siteid$ and t1.tbusinesstripid=$tbusinesstripid$