I found this code as an alternative to the join clause, and the guy states
Once again, please note that while the syntax above works great and still produces similar efficient results for Inner Join and Cross Join, it is not preferred ANSI standard syntax. It is suggested that for clarity of the code and to follow the standard, it is a good idea to use the explicit JOIN Keywords.
Clarity? Isn’t this understandable?
SELECT * FROM TableA a, TableB b WHERE a.condition1 = b.condition2
SELECT * FROM TableA JOIN TableB ON TableA.condition1 = TableB.condition2
I’ve done more digging but no understandable explanation why not to use this. Help?