List:General Discussion« Previous MessageNext Message »
From:Baron Schwartz Date:October 26 2007 4:02pm
Subject:Re: Comparing keys in two tables
View as plain text  
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
Thread
Comparing keys in two tablesAaron Fischer26 Oct
  • Re: Comparing keys in two tablesBaron Schwartz26 Oct
  • Re: Comparing keys in two tablesPeter Brawley26 Oct
    • Re: Comparing keys in two tablesAaron Fischer26 Oct
      • Re: Comparing keys in two tablesBaron Schwartz26 Oct
        • Re: Comparing keys in two tablesRob Wultsch26 Oct
          • Re: Comparing keys in two tablesBaron Schwartz26 Oct
      • Re: Comparing keys in two tablesPeter Brawley26 Oct
  • Re: Comparing keys in two tablesmysql26 Oct