Inner Join

[soukainab678690]

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

[Jonathon_wodnicki · Accepted solution]

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

[soukainab678690]

Hi,

Thank you for your response.

Regards ,