Function InnerJoin

join.go:19–21

InnerJoin selects records that have matching values in both tables. tables[0] is used as reference datatable.

(tables []*DataTable, on []JoinOn)

// InnerJoin selects records that have matching values in both tables.
// tables[0] is used as reference datatable.
func InnerJoin(tables []*DataTable, on []JoinOn) (*DataTable, error) {
	return newJoinImpl(innerJoin, tables, on).Compute()
}

// LeftJoin returns all records from the left table (table1), and the matched records from the right table (table2).
// The result is NULL from the right side, if there is no match.