Yeah, i guess it depends on the DBMS you are using. The JOIN keyword is not really necessary. It just makes it look nicer. If I remember correctly Oracle does not even support the join clause.