title: How to Join four Tables?
body: <p>I need to join three tables into the sale table, I tried left join but it does not join properly. can you guys plz give a solution.
  <a href="https://i.stack.imgur.com/qGcaM.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qGcaM.jpg" alt="enter image description here" /></a></p>
  <pre><code>Sale Tabel
  MSISSND    Agent_ID    Connection_Date   District
  3455         22           22-Jan-2020      abc
  1222         22           12-Feb-2020      abc 
  4562         25           23-Feb-2020      zxy
  8907         23           12-Mar-2020      rty 
  
  Agent Tabel
  Agent_ID  Agent_name  Distributor_ID   Distributor_name
  22         nikon          12              A-Z
  23         cannon         13              tech
  25         hp             14              hp-tech
  
  Customer Tabel
  MSISSND     Name     Address
  3455        nilak    adcd
  4562        suman    sdfg
  8907        nizar    ewrt
  1222        rowan    fgsk
  
  Target Tabel
  Distributor_ID    District    Month     Target
  12                  abc       Jan_2020    10
  12                  abc       Feb_2020    15
  13                  rty       Feb_2020    20
  14                  zxy       Mar_2020    24
  
  Output_final table will be
  MSISSND   Agent_Id  Agent_name   Conection_Date  Connection_MON_YEAR  District  Distributor_ID  Distibutor_name  Target   Name    Address
  3455       22         nikon        22-Jan-2020       Jan-2020            abc    12                     A-Z         10      nilak      adcd 
  </code></pre>