我有以下SQL,以两种不同的方式选择文章。所有文章都存储在Articles表中。有些被标记为本月文章(Articles_Fitness),而另一些则被标记为纯粹健身文章(ArticlesInCategories)。
我的问题是,我需要选择Files_Fitness.StartDate和Articles.PublicationDate作为Formatted_Date。这是可能的,还是我需要将其中一个标记为Formatted_Date1和Formatted_Date2,然后检查我输出它的时间?
SELECT
Articles.ArticleID,
Articles.Title,
Articles.Author,
Articles.Abstract,
date_format(Articles_Fitness.StartDate, '%M %d, %Y') AS Formatted_Date,
date_format(Articles.PublicationDate, '%M %d, %Y') AS Formatted_Date
FROM
Articles
LEFT JOIN Articles_Fitness
ON Articles_Fitness.ArticleID = Articles.ArticleID
AND Articles_Fitness.StartDate <= CURDATE()
LEFT JOIN ArticlesInCategories
ON ArticlesInCategories.ArticleID = Articles.ArticleID
AND ArticlesInCategories.CategoryID = '1'
WHERE
Articles.Body IS NOT NULL AND
Articles.Body != '' AND
Articles.Public ='1'