Finding unlinked records

[NeilT123]

Using GM 6.70.70226

We have a number of emails which have been filed before being linked to a contact. Is it possible to use an SQL query to find those emails?
If so can anyone provide the sql?

 

[DJHunt]

How about something like:

select *
from MailBox
where AccountNo <= ''

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- The Hacker's Guide to GoldMine Premium
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US/Default.html

 

[NeilT123]

D J I pasted your code into SQL query box, press query and I get the table headers but no records.

 

[NeilT123]

select *
from MailBox
where AccountNo is Null
Works

 

[DJHunt]

Than that is the one to use.

DJ Hunt
Phone: (978)2-3333
WebSite:

http://www.DJHunt.US

- The Hacker's Guide to GoldMine Premium
- One-on-One GoldMine Technical Support ( Fee Based )

http://www.DJHunt.US/Default.html