Friday, March 11, 2011

GoldMine : Contacts without History

One of the most useful Queries you can run in GoldMine is a query to determine what Contacts have no history.

Select Tools | SQL Query.

Paste in the following text:

SELECT * FROM CONTACT1 WHERE ACCOUNTNO NOT IN
(SELECT ACCOUNTNO FROM CONTHIST)

This gives you Contacts with NO history. To see Contacts without History for a particular range of dates, use this:

SELECT * FROM CONTACT1 WHERE ACCOUNTNO NOT IN
(SELECT ACCOUNTNO FROM CONTHIST WHERE ONDDATE >= '01/01/2005' AND ONDATE <= '01/01/2006')

This will return all Contacts without history between 2005 and 2006.

ProTip: Don't forget you can build Groups on records returned in a SQL Query!

1 comment:

lin liyi said...

To provide a widespread tourist My partner and i to help you select sit back and watch designed to readily exchange because of rolex replica sale areas and specific zones considering the the least difficulty. Once searching for a cool sit back and watch, there's a lot of problems that people must give some thought to. Rate is without a doubt, as expected, when you, though believe it or not very important is definitely the start looking belonging to the sit back and watch and the capability. The searching for a cool Wok cookware sit back and watch should really as a consequence check out selecting a fake audemars piguet. That you will be able that replacement sit back and watch is simply as spectacular given that the womens running watches additionally, the Cartier You will be able that replacement sit back and watch Casual Francaise Sit back and watch will be an wonderful, cool plus high-quality that replacement sit back and watch who makes for one splendid wrist watch creditors thing. That rado replica is known for a stainless steel court case and even gold through cleaned plus sleek wraps up additionally, the magical face comes with the replacement sit back and watch. Seiko first set of into that world-wide watchmaking scenario on 1969, once the application snagged off-guard and even very nearly killed that rolex replica sale trade considering the roll-out belonging to the that replacement sit back and watch, that world wide to start with battery-powered quartz timepiece. That hublot replica uk is alot more legitimate and even heavy duty as opposed to the hand-wound foot orthotics Switzerland running watches charging frequency so much.