Even using this syntax you may run into the following error:

The type of one of the expressions in the join clause is incorrect.