DigiGuide Library

SELECT Programme.strName, Programme.nID, Programme.bHasEpisodes, Programme.nCategoryID, Programme.strName, Category.strName AS strCategoryName FROM Category INNER JOIN Programme ON Category.nID = Programme.nCategoryID WHERE (((Programme.bHasEpisodes)<>0)) ORDER BY Programme.nCategoryID, Programme.strName