4 ms·

Other than some implementation tricks (optimizing broadcast joins, etc.), how is he wrong? That’s basically the definition of a JOIN.

• skybrian 8y ago
  The "implementation tricks" are essential optimizations.
  • elcritch 8y ago
    For most usable systems, sure. For a functionally correct but slow implementation, nope.
  • e12e 8y ago
    Technically JOIN without a where could mean CROSS JOIN? https://en.m.wikipedia.org/wiki/Join_(SQL)#Cross_join https://en.m.wikipedia.org/wiki/Join_(SQL)#Cross_join