> 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.