SELECT TOP 1 a.*,c.FileNames, c.FilePath, c.FileSize, c.FileExt, Convert(varchar(16),a.RegDate, 120) RegDates FROM dbo.T_BoardTable a LEFT JOIN (SELECT * FROM dbo.T_BoardFile WHERE DelUserSeq IS NULL) c ON a.ContentSeq = c.ContentSeq WHERE a.BoardSeq = '1001' AND a.ContentSeq = '1218' AND c.DelUserSeq IS NULL
