viewnews

MySQL error 1054: Unknown column 'cat.name' in 'field list'
When executing:
SELECT news.news_id,news.title,introtext,full_text,news.start_date,news.end_date, news.date_modified, status, cat.name as cat_name FROM news left join category cat on cat.category_id = news.category_id where status=1 and start_date <= DATE(Now()) and end_date>=DATE(Now()) order by start_date desc