[coolgeek]

Yeah, that's a problem.

FK JOIN was a casually tossed off addition that, in retrospect, I shouldn't have included.

[JoelJacobson]

As for your other comments, sounds like we are in agreement on (1) and (3), but just weigh pros/cons differently.

> 2) That's not at all clear from your example. Nor does it necessarily follow from the proposal in general

Can you provide a counter-example that will not be conciser when written using the foreign key join syntax?