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 ?
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.
Thank you for your response.