close
select
[前三次Remark]=
(
select '('+dbo.fyymmdd(fse_comment_date)+')'+CHAR(10)+'●'+fse_comment from
(select p1.*,
(select count(*) from DesignT_DesignT_DODIDW_Comment as p2 where p2.unique_id> p1.unique_id and p2.faedesign00=p1.faedesign00) as c
from DesignT_DesignT_DODIDW_Comment as p1 where p1.faedesign00=DesignT_DODIDW.unique_id
) as A where c=3
)
from DesignT_DODIDW
[前三次Remark]=
(
select '('+dbo.fyymmdd(fse_comment_date)+')'+CHAR(10)+'●'+fse_comment from
(select p1.*,
(select count(*) from DesignT_DesignT_DODIDW_Comment as p2 where p2.unique_id> p1.unique_id and p2.faedesign00=p1.faedesign00) as c
from DesignT_DesignT_DODIDW_Comment as p1 where p1.faedesign00=DesignT_DODIDW.unique_id
) as A where c=3
)
from DesignT_DODIDW
全站熱搜
留言列表
