Thread

Re: Foreign key joins revisited

Adam Brusselback <adambrusselback@gmail.com> — 2021-12-28T19:47:19Z

 > How about JOIN WITH?
I'm -1 on this, reusing WITH is just likely to cause confusion because WITH
can appear other places in a query having an entirely different meaning.
I'd just avoid that from the start.

>> Can with think of some other suitable reserved keyword?
>FOREIGN?  Or even spell out "JOIN FOREIGN KEY".
I like the conciseness of just FOREIGN.