…matched then … where …

Apache DerbyBigQueryDb2 (LUW)H2Oracle DBPostgreSQLSQL Server20072009201120132015201720192021✓ 11gR1+a⚠ 1.4.198 - 1.4.200ab
  1. ⚡Implementation-defined resolution of ambiguous column names
  2. Qualified identifiers not always accepted