confused between Union and AND Join Activity in Adobe Campaign Classic | Community
Skip to main content
S
Shrutii
Level 4
March 25, 2024
Solved

confused between Union and AND Join Activity in Adobe Campaign Classic

  • March 25, 2024
  • 2 replies
  • 1475 views

@Parvesh_Parmar ,@AkshayAnand 

,@isahore ,@AndreaBriceno,@ParthaSarathy

,@ParthaS ,@Craig_Thonis ,@Manoj_Kumar_ ,@Amine_Abedour ,@Marcel_Szimonisz,@DavidKangni 

,@Amit_Kumar,@ShashankNigam02,@Ganesh5067, @Jonathon_wodnicki

@Denis_Bozonnet 

Hi All,

 

I just read the documentation about AND join activity in Adobe Campaign but got confused between the purpose of AND Join activity and Union activity in Adobe Campaign

can someone please please help to explain exact difference AND Join activity and Union activity in Adobe Campaign

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

Hi @shrutii ,

AND join and Union activity are completely different activities which serve different purposes.

Example if you are connecting 2 query activity's output transition to a union activity, the result of 2 queries will get grouped into a single target output.

Union Activity

 

Whereas when you are connecting 2 query activity's output transition to a AND join, the output result of AND join will be the result of the query activity which you had set as Primary set inside AND activity.

AND-Join

2 replies

ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorAccepted solution
Community Advisor
March 25, 2024

Hi @shrutii ,

AND join and Union activity are completely different activities which serve different purposes.

Example if you are connecting 2 query activity's output transition to a union activity, the result of 2 queries will get grouped into a single target output.

Union Activity

 

Whereas when you are connecting 2 query activity's output transition to a AND join, the output result of AND join will be the result of the query activity which you had set as Primary set inside AND activity.

AND-Join

~  ParthaSarathy S~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
    I
    InMo
    Level 3
    March 26, 2024

    Hi @shrutii 

    The SQL JOIN is used when we have to extract data from more than one table.

    The SQL UNION is used when we have to display the results of two or more SELECT statements (from tables).

     

    In the case of SQL JOINS, the records are combined into new columns.

    In the case of SQL UNION, the records are combined into new rows.

     

    Same way in Adobe campaign classic, you can check what your incoming temp tables are, and based use case, you can either use JOIN or UNION operation.

    Hope this helps.

     

    Regards,

     

     

      Terms & ConditionsAccessibility statement

      Loading footer...