Thanks for your help.
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 02, 2007 10:47 AM
To: Weston, Craig (OFT); mysql@lists.mysql.com
Subject: Re: [mysql] reverse join
Craig
>How do I pull out all the non-duplicate records?
W
Craig
How do I pull out all the non-duplicate records?
With an exclusion join. To find non-duplicates with respect to one key...
SELECT keycandidate
FROM tbl t1
LEFT JOIN tbl t2 ON t1.keycandidate=t2.keycandidate
WHERE t2.keycandidate IS NULL;
To expand the comparison to multiple keys...
SE