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.