I was wondering what ANSI SQL standard would be most beneficial.
I haven't touched databases in over a year and I am refreshing my mind a bit.
What is the benefit of using the 99 syntax over the 92 syntax?
The older method seems less confusing and that is the one I did use.
I need to some work in sql server. I am reading some books and the authors all seem to push for the newer standard.

Why would I use a inner join over a where clause?

cheers