select  LOWER( c.VALUE ) Company, w.NAME WorkerName, e.VALIDFROM EmploymentFrom, e.VALIDTO EmpoymentTo
from HCMEMPLOYMENT e
left join HcmWorkerDetailsView w on w.PARTITION = e.PARTITION and w.RECID = e.WORKER
left join DIMATTRIBUTECOMPANYINFO c on c.PARTITION = e.PARTITION and c.RECID = e.LEGALENTITY
where w.NAME like 'WorkerName%'