when you place the join condition in where clause, it will act as a cross join before where condition then after it will take join condition which you mentioned in where clause. it will shows huge impact on performance when we have huge amount of data. other side; when we place join condition on join it does not act like cross join.