CBO_Research
Research
SELECT e.ContactIntID,e.DisplayName as Contact,e.CompanyName,a.ApptType as Type,a.ApptSubType as SubType,a.RemIntID as MLinkIntID,a.Subject,a.StartDateTime AS DateAndTime,
Mid(a.UserIDs,2,Len(a.UserIDs)-2) as UserID
FROM Reminders a, Links b, Links c, Contacts e
WHERE a.RemType='Status' AND a.ApptType='Status' AND
(a.RemIntID=b.FromID and b.ToID=e.ContactIntID) AND
(a.RemIntID=c.FromID and c.ToID='[[SelectedIntID]]')
UNION
SELECT "" as ContactIntID,"" as Contact,"" as CompanyName,a.ApptType as Type,a.ApptSubType as SubType,a.RemIntID as MLinkIntID,a.Subject,a.StartDateTime AS DateAndTime,
Mid(a.UserIDs,2,Len(a.UserIDs)-2) as UserID
FROM Reminders a, Links b
WHERE a.RemType='Status' AND a.ApptType='Status' AND
(a.ApptSubType='Call Connect' OR a.ApptSubType='Call Failure' OR a.ApptSubType='Call Message' OR a.ApptSubType='E-mail Candidate' OR a.ApptSubType='E-Mail Client') AND
(a.RemIntID=b.FromID and b.ToID='[[SelectedIntID]]')
Date
Desc
MLinkIntID
ContactIntID
MergeRestrictAll