title: Clarification on PL/SQL JOINS in this Query
body: <p>I have a Query returning 377 Rows</p>
  
  <pre><code>Select Cm.Customerid,Cm.Customername,Ad.Addressid,Ad.Addressline1,
  Stm.Statename,Ctm.Cityname,Dm.Districtname 
   From Crm.Customers Cm 
  inner join Crm.Customeraddress Ad on Ad.Customerid=Cm.Customerid
  Inner Join Ehis.Statemaster Stm On Stm.Stateid=Ad.Stateid
  Inner Join Ehis.Citymaster Ctm On Ctm.Cityid=Ad.Cityid
  inner join Ehis.Districtmaster dm on Dm.Districtid=Ad.Districtid
  </code></pre>
  
  <p>But if i add one more join to this (i.e)</p>
  
  <pre><code>Select 
  Cm.Customerid,Cm.Customername,Ad.Addressid,Ad.Addressline1,
  Stm.Statename,Ctm.Cityname,Dm.Districtname 
   From Crm.Customers Cm 
  inner join Crm.Customeraddress Ad on Ad.Customerid=Cm.Customerid
  inner join crm.agreements ag on ag.customerid=cm.customerid
  Inner Join Ehis.Statemaster Stm On Stm.Stateid=Ad.Stateid
  Inner Join Ehis.Citymaster Ctm On Ctm.Cityid=Ad.Cityid
  inner join Ehis.Districtmaster dm on Dm.Districtid=Ad.Districtid
  </code></pre>
  
  <p>My query is not returning any rows. Is there any Problem in using inner join for statemasters,city n district masters. Pls clarify the same.</p>