adonis join condition code example

Example: adonis join condition

let posts = await Posts
  .query()
  .leftJoin(‘post_titles’, function () {
  this
      .on(‘post_titles.post_id’, ‘posts.id’)
      .andOn(‘post_titles.lang_code’, Database.raw(’?’, [‘EN’]))
  })