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 ?

ali_hijazi‌

[elie_issa]

as shown in the attached picture the two tables are linked by Vacancy ID.

If we generate the vacancy table alone we have for example vacancy id : 3060

while this vacancy doesn't have a row in the assignment table.

when we reload the assignment table the vacancy id 3060 will not show.

I have tried the outer join , join and now as shown in the attached pic i tried not to join the two tables, leave them separate and linked with a unique key field (vacancy id) but no solution till now.

[agigliotti]

what is your current output and what is your expected result ?

[enricocamerin]

shouldn't be the opposite ?

outer join(Vacancies)

Load *

Resident Assigment;

[elie_issa]

we found now that the problem is from the section access security because we are making the security on a field found in the assignment table and in this case the field will be null if no assignment then the record is removed :S and we need to do the security in such way.