right_trivial.sql 219 B

12345
  1. PRAGMA DisableSimpleColumns;
  2. select coalesce(Input1.key, "_null") as a, coalesce(Input1.subkey, "_null") as b, coalesce(Input3.value, "_null") as c
  3. from plato.Input1
  4. right join plato.Input3 using (key)
  5. order by a, b, c;