SELECT a.emp_name,a.dept_joining_date,a.inst_joining_date,a.qualification,a.pan_no,a.payscale ,b.post_name,a.sr_no,a.post_code,a.dept_code,a.scale_code FROM employee a , post_master b WHERE a.dept_code='003' and a.post_code=b.post_code order by a.sr_no,a.post_code Department :Electrical