2 Replies Latest reply: Feb 16, 2018 11:47 AM by David Forest RSS

    Change Full Outer Join to Inner Join

    Massimo Favaro

      Hello everyone.

      I have a question about the relationship between tables.

      I have uploaded two tables:

       

      Screenshot_2.png

      and the relationship between these two tables should be "Full Outer Join", right?
      My question is: is it possible to change this relationship to inner join?

      I know I can join these two tables in the script but I'd prefere to keep the tables divided

      (i joined them with this script:

      [JoinedTable]:

      SQL SELECT "id",

           .......

      FROM XYZ.UserDetails;

      INNER JOIN

      SQL SELECT "id",

          "account_id",

          ...

      FROM XYZ.Users;)

        • Re: Change Full Outer Join to Inner Join
          Gysbert Wassenaar
          and the relationship between these two tables should be "Full Outer Join", right?

          Joins are used to join tables so the result is one table. A Full Outer Join is not a relationship but an operation.

           

          My question is: is it possible to change this relationship to inner join?

          An inner join is also an operation, not a relation.

           

          I know I can join these two tables in the script but I'd prefere to keep the tables divided

          Then load the tables separately and don't join them.

          • Re: Change Full Outer Join to Inner Join
            David Forest

            no, you cannot specify the inner/outer-ness of the logical connection between tables in your data model.

            What is the end goal?

            You may be able to "filter" out rows by looking at missing values in the other table.

            if([user detail].somefield is null,'',[user id].datapoint)