anyjoin_common_dup.sql 437 B

123456789
  1. /* syntax version 1 */
  2. PRAGMA DisableSimpleColumns;
  3. use plato;
  4. select * from Input1 as a right join Input2 as b on a.k1 = b.k2 order by a.v1, b.v2;
  5. select * from any Input1 as a right join Input2 as b on a.k1 = b.k2 order by a.v1, b.v2;
  6. select * from Input1 as a right join any Input2 as b on a.k1 = b.k2 order by a.v1, b.v2;
  7. select * from any Input1 as a right join any Input2 as b on a.k1 = b.k2 order by a.v1, b.v2;