[pas]

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]

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