SQL inner join problem -

The following SQL query is not working. I think that the error 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 tbl_news INNER Join tbl_news on tbl_users .creator = tbl_users.id order date DESC  

try it:

  SELECT SUBSTRING (tbl_news.comment, 1, 250) As a comment, tbl_news.id, tbl_news.date, tbl_news.subject, tbl_users.username fROM tbl_news Join INNER tbl_users tbl_news .creator = tbl_users.id Date by date DESC