SELECT PostTags.PostId, PostTags.TagId, Tags.Id, Tags.Tag...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Gardening and Landscaping

Q&A for gardeners and landscapers

--tagu veids un līdz ar to arī skaits dažos ierakstos tabulās Posts un PostTags ir atšķirīgs
SELECT PostTags.PostId, PostTags.TagId, Tags.Id, Tags.TagName, Posts.Tags
FROM PostTags, Tags, Posts
WHERE PostTags.TagId=Tags.Id AND PostTags.PostId=Posts.Id
AND PostId IN (14, 66)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results