Besides the known pros and cons of KEY JOIN, I like this clause because it saves me coding (and reading) time by using semantics I have already put into my table's FK definitions. AFAIK, however, KEY JOIN is still a vendor extension. Are there any plans to put this into an SQL standard? (Just because it's nice to use a standard SQL feature.) |
@volker, +1 nice question! I use it all time too.