Re: Comparing keys in two tables

[Baron Schwartz]

Aaron Fischer wrote:
> Thanks Peter and Baron, these both worked well.
> 
> The "left join on" took .1919 seconds and the "left outer join as" took 
> .1780 seconds.

They are synonymous in MySQL.  The only difference is 6 extra characters 
in the query text.  The difference was probably due to caches.

Baron