Re: Comparing keys in two tables

[Peter Brawley]

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
>>
>
>