title: Nested sub-query to select from more than tow table
body: <p>I have three tables:</p>
  
  <pre><code>Years (YearId,Year)
  Months (MonthID,Month)
  Date (DateID,YearID,MonthID)
  Client (CLientID,ClientName)
  Payment (PayID,ClientID,DateID,Amount)
  </code></pre>
  
  <p>I want to fill in DataGridView as: </p>
  
  <pre><code>Client Name, Amount, Year, Month 
  </code></pre>
  
  <p>I used this statement but it didn't work: </p>
  
  <pre><code>Select * From (select Year From Years Where YearID = (Select YearId From Date Where dateID = (Select DateID From Payment))),(Select Month From Months Where Monthid = (Select MonthID From Date Where dateID = (Select DateID From Payment))),(Select ClientName From Client Where ClientID = (Select ClientID From Payment),(Select amont From Payment)
  </code></pre>