1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for pro webmasters

-- Tag names that have plural counterparts

SELECT S.TagName, S.Count AS [Singular], P.Count AS [Plural]
FROM Tags AS S, Tags AS P
WHERE P.TagName = S.TagName + 's'
AND S.Count > 0
AND P.Count > 0;

fork query

created apr 21 11 Michael Mrozek