How use several inner join in meteor-postgreSQL?

help
1

Hello,

in my project i want several inner join or left join but it’s doesn’t work.

I can’t use several inner join why ? I can only on inner join by requete.

Maybe I don’t know the syntax because i write this :

sejour.publish('sejour', function() {
    return sejour.select('date_debut_sejour','date_fin_sejour','nb_personne','id_client','id_chambre','reglement.id as id_reglement','reglement.type_reglement')
    .join(['INNER JOIN'], ["id_reglement"], [["reglement", ['id']]])    
    .limit(100);
  });

Now, how use a second inner join in this requete ? it’s very important

Best regards,