Hi,
i have doubt on table structure and design itself
in Workplace if its Primary key
then how can you put EmpNumber with it
each Employee have different Workplacecode ? if yes then what is NumOfEmployees in Workplace and address_id
if table fine according to you then please share some fake data so can give batter result
as far as your query left join seems ok.