Is there anyway I can make this query(simplified edition) work in Advanced Find:
SELECT
APO.activitytypecodename,APO.owneridname,APO.regardingobjectidname, PCA.actualstart,APP.scheduledstart
FROM dbo.ActivityPointer APO
LEFT JOIN dbo.PhoneCall PCA ON APO.activityid = PCA.activityid
LEFT JOIN dbo.Appointment APP ON APO.activityid = APP.activityid
WHERE (PCA.category = 'Category1' OR APP.Category = 'Category1')
I want to show all phonecalls and appointments having category='Category1' but I'm not able to set the OR-operator to work different entities...
*This post is locked for comments
I have the same question (0)
