while select emplTable join dirPartyTable where emplTable.partyId == dirPartyTable.partyId outer join hRMEmplLeave where hRMEmplLeave.emplId == emplTable.EmplId