Hi,

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 sales.pk = customer.pk

with this

... FROM sale, customer WHERE sale.pk = customer.pk

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

Thanks
Sandy
Adept Software