Get data from multiple table
===

**Medical_Master**

           MedicalID MedicalName
           1(pk)     abc
           2         xyx
           3         pqr
           
**Child_Medical_Master**

           ChildMID MedicalID Station Name
           1(pk)    1(fk)     bnb     mfk
           2        1         def     rwr
           3        2         re      wrw      
        
**Medical_Visit**

           VTID  PMID  RFMID age
           1(pk) 2(fk) 1      34
           2     2     3      45
           3     3     1      45
           4     1     2      44
           5     2     2      76
           
**Medical_Study**

           UID   VTID  ChildMID SMID   Date  time 
           1(pk) 1(fk) 1        1      kk    jdj
           2     2     3        2      kdf   lfl
           6     3     2        3      rgr   rtr
    
**Doctor_Master**

           RFMID  Doctorname
           1(pk)  mr.john
           2      mr.jack
           3      mr.jim
           
**PAtient_Master**

           PMID   Firstname LastNAme
           1(pk)  df         ere
           2      rwe        rwer
           3      rwr        fwr
           
**Study_Master**

           SMID   MedicalID Description Duration
           1(pk)  1(fk)     fdf         efe
           2      1         ddf         dfdf
           3      2         df          ef



I want these columns from tables how should be my correct query?

    UID,PMID,FIRSTNAME,LASTNAME,AGE,MEDICALNAME,DESCRIPTION,STATION,DATE,DoctorName
     
i have use inner join on 7 tables but not getting correct data.(Doctorname is repeating)

    SELECT uid,PAtient_Master.PMID,Firstname,LASTNAME,age,MedicalName,Description,Station,Date,Doctorname
    FROM Medical_Master
    INNER JOIN Child_Medical_Master ON Medical_Master.MedicalID =Child_Medical_Master.MedicalID 
    INNER JOIN Medical_Study ON Child_Medical_Master.ChildMID=Medical_Study.ChildMID
    INNER JOIN Medical_Visit ON Medical_Visit.VTID=Medical_Study.VTID
    INNER JOIN Doctor_Master ON Doctor_Master.RFMID=Medical_Visit.RFMID
    INNER JOIN PAtient_Master ON Medical_Visit.PMID==PAtient_Master.PMID
    INNER JOIN Study_Master ON Medical_Study.SMID=Study_Master.SMID