How to find Duplicate Web Sites in GoldMine

Version 1

    Details

    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.


    Resolution

     

    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)