13 Replies Latest reply: Aug 2, 2018 9:14 AM by Elie Issa RSS

    Data missing after joining two tables

    Elie Issa

      Dear All,


      we have two tables :


      Assignments and Vacancies and the key is Vacancy id.


      In our case we could have some vacancies without assignment (no vacancy id in assignment table) but we need to show them in our dashboard.


      I tried to do the below outer join in my script but still without succeeding.


      outer join(Assignments)

      Load *

      Resident Vacancies;


      What could be the solution ?