Select a.mkey, c.type_desc DOC_TYPE, a.doc_no INWARD_NO,
convert(varchar, a.doc_date,103)date, a.to_user, a.No_of_pages,
 Ref_No, d.type_desc DEPT_RECEIVED,    b.first_name + ' ' + b.last_name EMP_RECEIVED,
b.first_name + ' ' + b.last_name NAME, b.email, a.Oracle_doc_no ORACLE_DOC_NO
 from inward_doc_tracking_hdr a , user_mst b ,type_mst_a c,type_mst_a d
where a.to_user = b.mkey  and a.doc_type = c.master_mkey
 and a.dept_received = d.Master_mkey and a.to_user = '1172'
 and a.doc_no = 'IW/16/66'

select * from inward_doc_tracking_hdr where doc_no = 'IW/16/66'