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]