joinSub method

@override QueryBuilder joinSub(QueryBuilder subQuery, String as, String firstColumn, [ String? operator, String? secondColumn, String type = 'inner', ])

Implementation

@override
QueryBuilder joinSub(
  QueryBuilder subQuery,
  String as,
  String firstColumn, [
  String? operator,
  String? secondColumn,
  String type = 'inner',
]) {
  String subSql = "(${subQuery.toSql()}) AS $as";
  String clause = "$type JOIN $subSql";
  if (operator != null && secondColumn != null) {
    clause += " ON $firstColumn $operator $secondColumn";
  }
  joins.add(clause);
  return this;
}