Search code examples
sqlsalesforceouter-joinexacttarget

Salesforce Marketing Cloud (ExactTarget) FULL OUTER JOIN

I'm trying to use FULL OUTER JOIN in my Marketing Cloud query but it doesn't returns any results. If I use just regular JOIN I can merge some data but it's not what I need. Need to use FULL OUTER JOIN to get all data from table A and if it's possible some extra data to it from table B. I'm using code bellow:

SELECT B.Email, A.abandon_reason, A.basket_url, A.promo_code, A.product_ids, A.datetime, B.FirstName, B.LastName, B.Marketing, A.qtys
FROM A
FULL OUTER JOIN B
ON A.ContactKey = B.Email
WHERE A.EmailSend = 'False'

Thank you for any help and suggestions.

Solution

  • Thank you for your responses. At the end I solved this problem with filtered DE.