import { SortThreeTables } from './sort_three_tables'; import { FilterThreeTables } from './filter_three_tables'; import { GroupThreeTables } from './group_three_tables'; import { EnforceNonEmptyRecord, ValueOrNestedValueRecord, ValueRecord } from '../../record'; import { Value } from '../../value'; import { Subtable } from '../subtable'; import { Table } from '../one/table'; import { SelectScalar } from '../selection/select_scalar'; import { SelectRows } from '../selection/select_rows'; import { SelectVector } from '../selection/select_vector'; import { AggregatableTable } from '../aggregatable_table'; import { SelectStatement } from '../../statements/select_statement'; import { JoinFourthTable } from '../four/join_fourth_table'; import { SelectGuaranteedSingleRow } from '../selection/select_guaranteed_single_row'; import { SelectSetsOfRows } from '../selection/select_sets_of_rows'; export declare class JoinThirdTable { private readonly statement; constructor(statement: SelectStatement); filter(predicate: (first: T1, second: T2, third: T3) => boolean): FilterThreeTables; filter

(provided: P, predicate: (parameters: P, first: T1, second: T2, third: T3) => boolean): FilterThreeTables; sortBy(sortBy: (first: T1, second: T2, third: T3) => Value): SortThreeTables; sortDescendinglyBy(sortBy: (first: T1, second: T2, third: T3) => Value): SortThreeTables; join(otherTable: Table, left: (firstTable: T1, secondTable: T2, thirdTable: T3) => K, right: (thirdTable: U) => K): JoinFourthTable; select(firstName: string, secondName: string, thirdName: string): SelectSetsOfRows<{ [first in K]: T1; } & { [second in K]: T2; } & { [third in K]: T3; }>; map(f: (first: T1, second: T2, third: T3) => EnforceNonEmptyRecord & U): SelectRows; map(tableInSubquery: Table, f: (s: Subtable, first: T1, second: T2, third: T3) => EnforceNonEmptyRecord & U): SelectRows; get(f: (first: T1, second: T2, third: T3) => U): SelectVector; count(): SelectScalar; max(f: (first: T1, second: T2, third: T3) => V): SelectScalar; min(f: (first: T1, second: T2, third: T3) => V): SelectScalar; sum(f: (first: T1, second: T2, third: T3) => V): SelectScalar; average(f: (first: T1, second: T2, third: T3) => V): SelectScalar; aggregate(aggregation: (first: AggregatableTable, second: AggregatableTable, third: AggregatableTable, count: () => number) => EnforceNonEmptyRecord & A): SelectGuaranteedSingleRow; groupBy(getKey: (first: T1, second: T2, third: T3) => EnforceNonEmptyRecord & K): GroupThreeTables; }