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