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
