lundi 30 mai 2016

Incorrect syntax near the keyword 'join'

My below query is causing an error:

Incorrect syntax near the keyword 'join'.

Select top 1 
    a.mkey, emp_received, a.mkey, 
    c.type_desc DOC_TYPE, a.doc_no INWARD_NO, 
    c.type_desc dept_received, c.type_desc EMP_RECEIVED,   
    convert(varchar, a.doc_date, 103) date,   
    a.to_user, a.No_of_pages, Ref_No, c.type_desc,   
    e.emp_name NAME, 
    ISNULL(e.Email_Id_Official, 'abc@test.com') EMAILID   
from 
    inward_doc_tracking_hdr a 
left join 
    type_mst_a c on a.doc_type = c.master_mkey 
                 and 
left join 
    type_mst_a c on a.dept_received = c.master_mkey 
left join 
    emp_mst e on a.emp_received = e.mkey  
where 
    a.emp_received is not null   
    and a.mkey = (select mkey 
                  from inward_doc_tracking_hdr aa 
                  where doc_no='IW/16/97')

I don't know why it is causing that error

Aucun commentaire:

Enregistrer un commentaire