SyntaxFix
Write A Post
Hire A Developer
Questions
Using the DISTINCT flag will remove duplicate rows.
SELECT DISTINCT C.Content_ID, C.Content_Title, M.Media_Id FROM tbl_Contents C LEFT JOIN tbl_Media M ON M.Content_Id = C.Content_Id ORDER BY C.Content_DatePublished ASC