I have a table containing Display Text, A Link Field, and a Category.
I am trying to find duplicate links, BUT only if they have the same Category.
Right now I am using a query that shows me all duplicates regardless of the category they are in. Can anyone help me figure out the missing piece for the same category part?
Here is my query:
Code:
SELECT *
FROM patterns
WHERE lnktxt
IN (
SELECT lnktxt
FROM patterns
GROUP BY lnktxt
HAVING count( lnktxt ) >1
)
ORDER BY lnktxt