Isn't a full outer join a Descartes product? And thus any other join is just a s... | Hacker News

Hacker News new | past | comments | ask | show | jobs | submit

login

pas on Sept 25, 2019 | parent | context | favorite | on: Comparing Database Types

Isn't a full outer join a Descartes product? And thus any other join is just a special case where rows get selected/projected/filtered out?

ithkuil on Sept 25, 2019 [–]

The Cross join is a Cartesian product. Good read: https://en.m.wikipedia.org/wiki/Join_(SQL)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact