How get record?.

["Amm85" <webforumsuser@xxxxxxxxxxxxxx>]

This query bring all records in tbl_emp.
 How can i find records with tbl_emp.status = 'retired' only?.

 select tbl_emp.id,tbl_emp.name,tbl_emp.st_date,tbl_dept.deptname
 from tbl_emp left join tbl_dept
 on tbl_emp.id = tbl_dept
 where tbl_emp.status = 'retired'