Approved tag synonyms having a non-existent target

1

Please login or register to vote for this query.

(click on this box to dismiss)

Programming Language Design and Implementation

Q&A for designers and implementers of computer programming languages

SELECT 
ts.SourceTagName AS [TagName],
ts.TargetTagName AS [TagName],
ts.ApprovedbyUserId AS [User Link],
* 
FROM TagSynonyms ts LEFT OUTER JOIN Tags t ON t.TagName=ts.TargetTagName
WHERE (t.Id IS NULL)
  AND (ApprovalDate IS NOT NULL)

Enter Parameters

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