Method join

lib/model.ts:710–722

Join a table to the current query. * * await Flight.where( * Flight.field("departure"), * "Paris", * ).join( * Airport, * Airport.field("id"), * Flight.field("airportId"), * ).get()

(
    this: T,
    joinTable: ModelSchema,
    originField: string,
    targetField: string,
  )

   *     ).get()
   */
  static join<T extends ModelSchema>(
    this: T,
    joinTable: ModelSchema,
    originField: string,
    targetField: string,
  ) {
    this._currentQuery.join(
      joinTable.table,
      joinTable.formatFieldToDatabase(originField) as string,
      this.formatFieldToDatabase(targetField) as string,
    );
    return this;
  }

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