DB Error: no such field

SQL:SELECT * FROM yoshiet_news,yoshiet_newsText LEFT JOIN yoshiet_category ON yoshiet_category.categoryID = yoshiet_news.categoryID WHERE newsStatus=1 AND newsTimeStamp <= 1265697649 AND ( limitDate > curdate() OR limitDate = '0000-00-00') AND yoshiet_news.newsID = yoshiet_newsText.newsID AND yoshiet_newsText.imageName!='' AND fileType='image' AND ( yoshiet_news.categoryID=1 ) GROUP BY yoshiet_newsText.newsID ORDER BY rand() limit 0,3