SELECT pub_category_id, category
SELECT pub.publication_id, pub.category, pub.bibliography_entry, pub.content,
cat.pub_category_id, cat.category as wordcategory
FROM publications pub, pub_categories cat
WHERE pub.category = cat.pub_category_id
ORDER BY cat.category, pub.bibliography_entry DESC
Jane's publications are divided into the following categories. Follow the links to individual
categories to view individual publications. Or simply browse down this page to view all publications.