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
BedrockMission!

Learn More

View all

Sign in to view all badges

Inner Join

Avatar

Avatar
Validate 1
Level 1
soukainab678690
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
soukainab678690
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
soukainab678690
Level 1

04-02-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile

Avatar
Contributor
MVP
wodnicki
MVP

Likes

941 likes

Total Posts

1,061 posts

Correct Reply

499 solutions
Top badges earned
Contributor
Shape 1
Give Back 100
Give Back 50
Give Back 25
View profile
wodnicki
MVP

04-02-2019

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

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
soukainab678690
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 1
soukainab678690
Level 1

Likes

3 likes

Total Posts

6 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 3
Boost 1
Affirm 1
View profile
soukainab678690
Level 1

01-03-2019

Hi,

Thank you for your response.

Regards ,