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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
