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)