03-28-2011 07:59 AM
With the limited target criteria in the campaign feature, I created a Group in the contact area. I next tried to pull the targets in via the group. I get a strange pop-up that I cannot resolve.
"The objects "Address" and "Address" in the FROM clause have the same exposed names. Use correlation names to distinguish them."
Any help would be much appreciated.
Solved! Go to Solution.
03-28-2011 08:28 AM
Can you paste the SQL from the Group up here?
03-28-2011 08:35 AM
SELECT A1.CONTACTID, A1.NAMELF, A1.ACCOUNT, A2.CITY A2_CITY, A2.STATE A2_STATE, A1.WORKPHONE, A1.MOBILE, A1.EMAIL, A1.ACCOUNTMANAGERID, A1.SECCODEID, A1.TITLE, A1.NAME FROM CONTACT A1 INNER JOIN ADDRESS A4 ON (A1.SHIPPINGID=A4.ADDRESSID) INNER JOIN ACCOUNT A3 ON (A1.ACCOUNTID=A3.ACCOUNTID) INNER JOIN ADDRESS A2 ON (A1.ADDRESSID=A2.ADDRESSID) WHERE (A1.EMAIL IS NOT NULL AND A1.EMAIL <> '') OR (A3.STATUS<>'Closed') AND (A4.COUNTRY='United States') OR (A4.COUNTRY='USA') ORDER BY A1.NAMELF ASC
03-28-2011 08:48 AM
You have two joins to the address table in the group but a quick test allowed me to do that with no problems.
Do you have more than one address table in your DB?
You could try running SLX Profiler at the time you try to add the targets and take a look at what it's doing.
03-28-2011 08:53 AM
We do have multiple addresses. I dropped one of the criteria, Country =USA and it worked.
What is the SLXProfiler?
03-28-2011 08:54 AM