Monday, 13 March 2017

joining multiple tables with knex.js

I have been working hard trying to join three tables with knex.js.

I want to use one get function to use the data in one ejs template.

I tried this solution but not work : https://github.com/tgriesser/knex/issues/443

here are the tables I want to join

table 1 : memberid, membername

table 2 : proudctid, productname

table 3 : memberid, productid, number

a member can have multiple products

table 3 : http://imgur.com/a/rxMlp

and by the way , if I want to get data using two function in one template how should I do ?

Can someone help me? Thanks



via Anymore

No comments:

Post a Comment