Month: March 2010

select address2, contsupref from contsupp where contsupref <>'' and rectype='p' and contact='E-mail Address' and contsupref in (select contsupref from contsupp group by contsupref having count(contsupref) >1) order by contsupref

Many clients have databases that have duplicate records. The SQL query below will return information based on the company name being duplicated in the database. select company,contact,address1, address2, zip,phone1 from contact1 where company <>'' and company in (select company from contact1 group by company having count(*) >1) order by company

For GoldMine Standard Edition (dBase) Do not rely on GoldMine's backup utility. The best way to back up GoldMine is to copy the entire goldmine folder (and its contents) to another location.  You can do this manually with a copy/paste or you can use any number of backup software programs or...

The following is a SQL Query that will display Additional Contacts with their Mailing Address, Email Address and the associated Email Merge Code and Mail Merge Code. select c1.accountno, c1.key1, ac.contact, ac.city, ac.state, ac.mergecodes, em.contsupref, em.mergecodes, substring(em.mergecodes,1,1) as CHECKED from contact1 c1 join contsupp ac on c1.accountno=ac.accountno join contsupp em...

select contact1.company, contact1.contact from contact1, contsupp where contact1.contact = contsupp.contact and contact1.accountno = contsupp.accountno order by contact1.contact