SQL inner join problem

Question

The following SQL query isn't working. I think the error is on the first line.

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

Answer 1

I don't think your alias as tbl_news.comment is allowed to have a dot in it. What error are you getting? What flavor of SQL is it? Thanks.

Answer 2

SELECT SUBSTRING(tbl_news.comment, 1, 250) as 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

Answer 3

Try this:

SELECT SUBSTRING(tbl_news.comment, 1, 250) as 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

Answer 4

Use:

  SELECT SUBSTRING(tn.comment, 1, 250) AS "tbl_news.comment", 
         tn.id, 
         tn.date, 
         tn.subject, 
         tu.username 
    FROM tbl_news tn
    JOIN tbl_users tu ON tu.id = tn.creator
ORDER BY tn.date DESC

Using single quotes on the column alias also worked for me on SQL Server:

  SELECT SUBSTRING(tn.comment, 1, 250) AS 'tbl_news.comment', 
         tn.id, 
         tn.date, 
         tn.subject, 
         tu.username 
    FROM tbl_news tn
    JOIN tbl_users tu ON tu.id = tn.creator
ORDER BY tn.date DESC