Re: How get record?.

["Amm85" <webforumsuser@xxxxxxxxxxxxxx>]

Sorry...i miss type...

 this is correct query...not working.

 This query bring all records in tbl_emp. i want only, tbl_emp.status = 
'retired' records.

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