diffrence between joins

S

Slaven Bojko

Hi!

Which one is better, faster, and can someone please explain me the
diffrence?

a)

.... table1 INNER JOIN table2 ON table1.fieldID = table2.fieldID WHERE
table1.field2> table2.field2

b)

.... table1 INNER JOIN table2 ON (table1.fieldID = table2.fieldID AND
table1.field2> table2.field2)

Thanks!

Regards,

Slaven

(please remove ".makniovo" from e-mail addres if you whish to send me a
e-mail)
 
M

Michel Walsh

Hi,


b) should be faster, but with just a little bit of chances, the
optimizer would be able to come with the same execution plan in both cases.
So, since a) keep the design grid "available" and b) does not, I may use
a), for maintenance reasons, NOT FOR SPEED...



Hoping it may help,
Vanderghast, Access MVP
 
S

Slaven Bojko

Thanks a lot for your answer. I think I'll go for a) for the same reasons...

Regards,

Slaven
 
Top