intersect method

void intersect(
  1. BaseSelectStatement other
)

Appends the other statement as a INTERSECT clause after this query.

The database will run both queries and return all rows that were returned by both queries. For this to work, this and other must have compatible columns.

The other query must not include a LIMIT or a ORDER BY clause. Compound statements can only contain a single LIMIT and ORDER BY clause at the end, which is set on the first statement (on which intersect is called). Also, the other statement must not contain compound parts on its own.

Implementation

void intersect(BaseSelectStatement other) {
  _addCompound(_CompoundOperator.intersect, other);
}