Hi, I have the following code in a stored procedure to retrieve all posts:SELECT Blog_Post.PostID, Blog_Post.PostTitle, Blog_Post.PostAuthor, Blog_Post.PostDate, Blog_Post.PostBody, Blog_Post.PostDescription, Blog_Post.Comments, Blog_Post.Publish, Blog_Post.Likes FROM Blog_Post WHERE Blog_Post.Publish = 1;
SELECT Blog_Category.CategoryID, Blog_Category.CategoryTitle, Blog_Post_Categories.PostID FROM Blog_Post_Categories INNER JOIN Blog_Category ON Blog_Post_Categories.CategoryID = Blog_Category.CategoryID ORDER BY CategoryTitle;
SELECT Blog_Tag.TagID, Blog_Tag.Tag, Blog_Post_Tags.PostID FROM Blog_Post_Tags INNER JOIN Blog_Tag ON Blog_Post_Tags.TagID = Blog_Tag.TagID ORDER BY TagHowever, I am having trouble selecting posts by their tag... Any help will be great. Thanks in advance!
View Complete Post