Module

x/denodb/mod.ts>Model.leftOuterJoin

MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno
Latest
method Model.leftOuterJoin
import { Model } from "https://dotland.deno.dev/x/denodb@v1.4.0/mod.ts";

Join a table with left outer statement to the current query.

await Flight.where(
  Flight.field("departure"),
  "Paris",
).leftOuterJoin(
  Airport,
  Airport.field("id"),
  Flight.field("airportId"),
).get()

Type Parameters

T extends ModelSchema

Parameters

this: T
joinTable: ModelSchema
originField: string
targetField: string