Adimpact.com

SQL Query for Secondary Contacts & their Email Addresses

December 18, 2006

in SQL Query

Here’s a SQL Query request that comes up often…  How to find all secondary contact and their email addresses:

Here ya’ go!

select contact1.company, contsupp.contact, contsupp2.contsupref + contsupp2.address1 from contact1, contsupp, contsupp as contsupp2 where contsupp.rectype = ‘C’ and contact1.accountno = contsupp.accountno and contsupp.recid = contsupp2.linkacct order by contact1.company

Now wouldn’t the GoldMine Guide To SQL Queries (http://www.thegmblog.com/sql4gm/) make a great Holiday gift for that special GoldMiner in your life?

GoldMine Blog Notification Form

{ 2 comments }

Ted Chmura III/TC3 Music 12.19.06 at 10:25 am

Nice Query ! Helped me clean OUT some Additional Contacts.

FWIW - the query returned all the Referral Records as well as the Additional Contacts.

Thanks !

Chad Smith 12.19.06 at 4:18 pm

Good catch — I updated the query to only bring up secondary contacts.

Comments on this entry are closed.

Previous post: Default Alarm Lead Time

Next post: Date Stamp your Group