Subject Join performance
Author Sandy

I've noticed several times recently that a simple step that seems to speed
up my queries (sometimes quite substantially) is to replace a join like...

... FROM sales INNER JOIN customer ON =

with this

... FROM sale, customer WHERE =

I was under the impression that both of these methods were pretty much the
same thing, but apparently not. What is the difference?

Adept Software