RethinkDB has a function called “outerJoin”, which actually does a left join. <\/p>\n
For example, this finds users and adds their audit trail history (if any):<\/p>\n
\nr.db('test')\n .table('user_actions')\n .outerJoin(r.table('users'),\n (action, user) => \n action('user_id').eq(user('id')))\n .zip()\n<\/pre>\nIf instead you want to start with audit history and add users (if they exist) you have to swap everything manually, since at this time there is no right join:<\/p>\n
\nr.db('test')\n .table('users')\n .outerJoin(r.table('user_actions'),\n (user, action) => \n action('user_id').eq(user('id')))\n .zip()\n<\/pre>\n","protected":false},"excerpt":{"rendered":"RethinkDB has a function called “outerJoin”, which actually does a left join. For example, this finds users and adds their audit trail history (if any): r.db(‘test’) .table(‘user_actions’) .outerJoin(r.table(‘users’), (action, user) => action(‘user_id’).eq(user(‘id’))) .zip() If instead you want to start with audit history and add users (if they exist) you have to swap everything manually, since … <\/p>\n