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