This is totally ridiculous. MIDDLE is not a keyword at all and there is no such thing called as a MIDDLE join. Here the word MIDDLE acts as if it is an alias to the table tab_a at the FROM area.