How to find Duplicate Web Sites in GoldMine

Version 1


    The following SQL statemtents can be run using the GoldMine SQL query tool, or through the SQL Management Studios.  This statement will help you located duplicate web addresses in your database.



    SELECT accountno,company,contact FROM contact1 WHERE EXISTS(SELECT 1 FROM contsupp WHERE rectype='P' and contact=’Web Sites’ AND accountno=contact1.accountno GROUP BY u_contsupref HAVING COUNT(*)>1)