Answer for:

SQL Statement in VB6 Code

Message 7 of 12

View entire thread
0 Votes

The style of join syntax simonlarsen is referring to has in fact been deprecated in favor of join syntax. That being said, no DBMS I'm aware of has discontinued support for the old syntax and although the new join syntax promises increase efficiency and speed, this primarily applies to very large data sets. Additionally, the old syntax is more human readable.