title: Create multiple INNER JOINS with Sequelize ORM
body: <p>I'm using Sequelize ORM with Node.js and I can't get my head around on how to build the following query with it.</p>
  
  <pre><code>SELECT service.*, serviceCollection.*, client.companyName, client.idclient 
  FROM service 
  INNER JOIN serviceCollection 
  ON service.serviceCollection_idserviceCollection = serviceCollection.idserviceCollection 
  INNER JOIN client 
  ON serviceCollection.client_idclient = client.idclient
  </code></pre>
  
  <p>This query works and runs fine when I try it on phpMyAdmin.
  The complication is that the Client model has no direct relation with Service, so when trying to do this : </p>
  
  <pre><code>Service.findAll({include : [ServiceCollection, Client]}).then(function(service){
      if(service) {
          res.status(200).json(service);
      }
  });
  </code></pre>
  
  <p>I get the following error : </p>
  
  <pre><code>Unhandled rejection Error: client is not associated to service!
  </code></pre>
  
  <p>How could I prepare the query in a way that would get the client information from the foreignkey in <strong><em>serviceCollection</em></strong> and not the original model - <strong><em>service</em></strong>.
  I can't just use <code>include</code> on <strong><em>client</em></strong> because it will give me the error, I need to associate it to this query some other way and I can't seem to find the solution in the documentation.</p>