title: Inner join with 3 tables in Visual Studio
body: <p>I am trying to do an inner join with 3 tables in Visual Studio but I am getting an error. When I do the inner join with only 2 tables it works.</p>
  
  <p>Here is my code for 3 tables:</p>
  
  <pre><code>"select b.bidID, b.userID, u.userFirstName, u.userLastName, c.clientName, b.productName, b.openingDate, b.status
  from Bid b
  inner join Client c on b.clientID = c.clientID
  inner join User u on b.userID = u.userID
  where b.clientID = '" + cId + "' ";
  </code></pre>
  
  <p>with 2 tables:</p>
  
  <pre><code>"select b.bidID, b.userID, c.clientName, b.productName, b.openingDate, b.status
  from Bid b
  inner join Client c on b.clientID = c.clientID
  where b.clientID = '" + cId + "' ";
  </code></pre>