List:General Discussion« Previous MessageNext Message »
From:Aaron Fischer Date:October 26 2007 3:59pm
Subject:Re: Comparing keys in two tables
View as plain text  
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