queryInclusionClause

A with or without clause that joins or anti-joins an additional aliased query source into the query. Multiple inclusion clauses may appear in a single query.

Examples

With clause (semi-join)

from [Encounter] E
  with [Condition: "Diabetes Mellitus"] C
    such that C.onset during E.period

Without clause (anti-join)

from [Encounter] E
  without [Procedure: "Excluded Procedure"] P
    such that P.performed during E.period
Railroad Diagram
100%
withClause withoutClause

scroll to zoom · drag to pan · click green rules or blue tokens to navigate

EBNF

queryInclusionClause
  : withClause
  | withoutClause
  ;

Used In