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
Hi there,
I have a situation where I have duplicate data within
several tables, but they are all indexed in the same way. How do I pull
out all the non-duplicate records?
Would I have to create a temporary table, add one data set, then add the
second where it doesn't equal the