Subject Re: what should i use where or join? whats the difference?
Author Svein Erling Tysvær
> I prefer to use SQL-92 syntax, I have heard that the optimizer works
> better with the SQL-92 (not sure at this point).

At least using JOIN is good for lazy programmers like me - I use IBO,
and using JOIN means that I do not have to fill in JoinLinks myself
(i.e. using JOIN makes it easier for some component sets figure how to
best do what you are asking). The only advantages I know of for
preferring the WHERE clause, is that you don't have to learn a new
word and that programmers even older than me have no problems
understanding the syntax (though I find JOIN more easily readable,
even though I'm old enough to originally have learnt how to join using
the WHERE clause).