confused between Union and AND Join Activity in Adobe Campaign Classic

[Shrutii]

@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

[ParthaSarathy · Accepted solution]

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

[InMo]

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,