Q&A about the site for Joomla! administrators, users, developers and designers
SELECT Tags.Id [Tag Link], Posts.Body FROM Tags INNER JOIN Posts ON Posts.Id = Tags.ExcerptPostId;