equi_join_three_asterisk.sql 182 B

1234567
  1. PRAGMA DisableSimpleColumns;
  2. /* postgres can not */
  3. SELECT A.*, C.subkey as goal,B.*
  4. FROM plato.A
  5. JOIN plato.B ON A.key == B.key
  6. JOIN plato.C ON B.subkey == C.subkey
  7. ORDER BY A.key;