except method

void except(
  1. BaseSelectStatement other
)

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

The database will run both queries and return all rows of the first query that were not returned by other. 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 except is called). Also, the other statement must not contain compound parts on its own.

Implementation

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