SQL : Join Tables
Join 2 (or more) tables together. LEFT JOIN is most commonly used method.
SELECT TOP 10
wiki_wiki.wikiID, wiki_wiki.name, wiki_wiki.bodyID, wiki_wiki.categoryID, wiki_wiki.modifiedDate, --columns from base table
wiki_category.name AS categoryName --column from joined table with alias name
FROM wiki_wiki --base table
LEFT JOIN wiki_category on wiki_category.categoryID = wiki_wiki.categoryID --the join
ORDER BY modifiedDate DESC --now order it newest