emptyjoin_unused_keys.sql 228 B

123456789101112131415
  1. /* syntax version 1 */
  2. use plato;
  3. insert into @Input1
  4. select '' as k1, '' as v1, '' as u1 limit 0;
  5. commit;
  6. select
  7. v3
  8. from @Input1 as a
  9. join Input2 as b on (a.k1 = b.k2)
  10. right join Input3 as c on (a.k1 = c.k3)
  11. order by v3;