Join issue

[#1]

I have this in my load script:

MAN_TRAININGS:

LOAD Distinct

          MAND_TRAINING_NAME,

          MAND_TRAINING_CODE AS TRAINING_CODE,

          MAND_TRAINING_GROUP

RESIDENT MandatoryTraining;

LEFT JOIN (MAN_TRAININGS)

          LOAD

                    EMPLOYEE_ID

          RESIDENT Career_Learning;

Now I don't see the training for employees when they have no training records.

In tha attachment my gauges. One is for colleagues having done the trainings and one is created for employees without training records (called mand_notokay). The table must look like the second image (mandokay.jpg) with 6 rows defined in table MAN_TRAININGS.

Thanks,

John