sql inner join problem

Posted by Luke on Stack Overflow See other posts from Stack Overflow or by Luke
Published on 2010-05-17T20:59:43Z Indexed on 2010/05/17 21:10 UTC
Read the original article Hit count: 285

SELECT SUBSTRING(tbl_news.comment, 1, 250) as tbl_news.comment, 
        tbl_news.id, tbl_news.date, tbl_news.subject, tbl_users.username FROM tbl_news
        INNER JOIN tbl_users ON tbl_news.creator = tbl_users.id
        ORDER BY date DESC

© Stack Overflow or respective owner