Questions

Answer for:

SQL Statement in VB6 Code

Message 10 of 12

View entire thread
+
0 Votes
kerry.millen

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.