Inner Join | Community
Skip to main content
soukainab678690
soukainab678690
Level 2
February 4, 2019
Solved

Inner Join

  • February 4, 2019
  • 2 replies
  • 2946 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    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

    2 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    February 4, 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

      soukainab678690
      soukainab678690Author
      Level 2
      March 1, 2019

      Hi,

      Thank you for your response.

      Regards ,

      Terms & ConditionsAccessibility statement

      Loading footer...