SELECT Categories.Cat_Name, Articles.Art_Date, Articles.Art_ID, Articles.Art_Heading, Articles.Art_Summary, Articles.Art_PicTag, Articles.Art_PicSmlUrl, Categories.Cat_Description FROM Articles JOIN ArticleCategories ON Articles.Art_ID = ArticleCategories.Art_ID JOIN Categories ON Categories.Cat_ID = ArticleCategories.Cat_ID WHERE Categories.Cat_ID = '#catID#' ORDER BY Articles.Art_Date DESC SELECT Categories.Cat_ID, Categories.Cat_Name, Count(Articles.Art_ID) AS Total_Articles FROM Categories JOIN ArticleCategories ON Categories.Cat_ID = ArticleCategories.Cat_ID JOIN Articles ON ArticleCategories.Art_ID = Articles.Art_ID GROUP BY Categories.Cat_Name, Categories.Cat_ID News by Category - #catName#

#catName#

#catDescription#

#Art_Heading#

#Art_PicTag# #DateFormat(Art_Date, "dddd, mmmm d yyyy")#

#Art_Summary# Read