我想用knex.js实现下面的sql代码: select c.id,c.parent_id,c.comment,u.username,c.postid from comments as users as u on (u.id = c.userid);我尝试这样做: db('comments AS c')
.join('post_details
我有这五张表,并有一个预期的结果加入他们。表JobShipment表头表支部表公司表注我的预期结果结果并不如我所料。as 'Dept', ST.ST_NoteText AS 'Note Text' LEFT JOIN Company gc (NOLOCK)on st.st_gc_relatedCompany = gc.gc_pk
LEFT JOIN</