SQL Learning Center - GoldMine » 2008 » September

Use SQL queries to get answers from GoldMine

September 11, 2008

Find all contacts sent a certain attachment

by Doug Steinschneider @ 9:11 pm. Filed under MSSQL History, MSSQL Email

Type: MSSQL
Description: Find all contacts sent a certain attachment

SELECT
c1.contact
,c1.company
,ch.rectype
,mb.maildate
,c1.accountno
FROM
contact1 c1
JOIN conthist ch
ON c1.accountno=ch.accountno
JOIN mailbox mb
ON ch.recid = mb.linkrecid
WHERE
mb.maildate > '11/01/2007'
AND mb.rfc822 LIKE '%Put attachment filename here%'

[Comments (0)] [link]

GoldMine SQL Tutorial:

General SQL Tutorials:

SQL Help Links:

Recommended Reading - SQL Books:

Expert (1)
Intermediate (1)

RSS:

Links:

Search For SQL Query:

GoldMine MS SQL Queries:

GoldMine dBase SQL Queries (LocalSQL):

21 queries. 0.069 seconds