List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:October 26 2007 4:47pm
Subject:Re: Comparing keys in two tables
View as plain text  
Aaron

 >The "left join on" took .1919 seconds and the "left outer join as" 
took .1780 seconds.

Caching :)

PB

-----

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.
>
> =)
>
>
> On Oct 26, 2007, at 11:37 AM, Peter Brawley wrote:
>
>> Aaron
>>
>> An exclusion join:
>>
>> SELECT a.col
>> FROM a
>> LEFT JOIN b ON a.col=b.col
>> WHERE b.col IS NULL;
>>
>> PB
>>
>
>
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