how long before I get tag badges?
Q&A for professional and enthusiast programmers
SELECT top 10 A.TagName, B.TagName, (select count(*) from PostTags pt where pt.tagid = b.id) as occured FROM Tags as A, Tags as B WHERE A.id <> B.id AND EXISTS ( SELECT * FROM PostTags as C, PostTags as D where C.PostId=D.PostId and C.TagId=A.id and D.TagId=B.id) and a.tagname = 'java' --SELECT * FROM PostTags as C, PostTags as D where C.PostId=D.PostId and C.TagId=1 and D.TagId=17 --select * from posttags where PostId=10980