Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

The 4th edition of the Campaign Community Lens newsletter is out now!
SOLVED

Inner Join

Avatar

Level 2

Hello ,

I'm trying to filter some data using the "generic query editor" but the results I got are not correct because I don't know why the generated SQL is a LEFT JOIN .

How can I do an Inner join using the "generic query editor " or through the option "Profiles and Targets --> Predefined filters"

I only get the result if I use Query in the workflow where it allows me to specify a filtering dimension .

And why ADobe Campaign only do a Left Join, how can I force it to use an Inner Join ?

Thank you

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

To left-join with GQE you have to statically define the relationship in either schema's definition, (rev)externalJoin="false" (default), or use a workflow to dynamically join 2 query activities with an enrichment.

Thanks,

-Jon

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi,

To left-join with GQE you have to statically define the relationship in either schema's definition, (rev)externalJoin="false" (default), or use a workflow to dynamically join 2 query activities with an enrichment.

Thanks,

-Jon

Avatar

Level 2

Hi,

Thank you for your response.

Regards ,