2 ms·
> For one thing, in SQLite, it doesn't. It does now, since the latest release 3.39, along with full join.
by debugnik 4y ago
> For one thing, in SQLite, it doesn't.
It does now, since the latest release 3.39, along with full join.
- samatman 4y agoThat's great news! It'll be a long time before one can use it in portable SQLite queries, for those cases where that matters. I'll continue to eschew the right join for the clarity of only thinking about that relation in one way, but we statically link SQLite for several good reasons, including being able to use new features as they arrive. Full join is certainly a welcome addition.