Select A.title, (SELECT Up_File FROM TBL_Bbs_File WHERE idx = A.idx ORDER BY idx LIMIT 0, 1) AS file_nm from tbl_bbs A where A.kind_type = 'kind1' and A.idx = '143'