The following would be syntax to create the 3rd table.
Load * Resident REPORT_QUOTA;
Load * Resident REPORT_ASSIGNEMENT where not isNull(FULFILMENT_ID);
The join on QUOTA_ID is automatic as QlikVIew works on natural joins. Once you create the 3rd table drop the two tables if you dont need them, else syntehetic keys will be created.