Hi Everyone,

Is query #1 as optimized as query #2:

QUERY #1
SELECT one,two FROM table1,table2 where table1.id = table2.id

QUERY #2
SELECT one,two FROM table1 INNER JOIN table2 ON table2.id = table1.id

Or are they both equally as fast? I'm using VFP 5.0.

I'm not concerned about which one is *SQL* correct... just speed.

THANKS!