Select a.Re_userid,a.Re_contents,b.txt_kname,A.re_regdate,a.idx From board_reply as A Inner Join blind_Member as B on a.Re_userid=B.txt_userid Where a.re_Isdel = 0 and A.table_Idx='50' and A.table_name='board_notice' Order by a.Re_regdate desc