Model | /mod.ts | denodb@v1.0.40

MySQL, SQLite, MariaDB, PostgreSQL and MongoDB ORM for Deno

Popular

method Model.leftOuterJoin

import { Model } from "https://deno.land/x/denodb@v1.0.40/mod.ts";

leftOuterJoin<T extends ModelSchema>(

this: T,

joinTable: ModelSchema,

originField: string,

targetField: string,

)

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

this: T

joinTable: ModelSchema

originField: string

targetField: string