Oops, you are correct. I missed a "not" in the original post.
-Sheeri
On 10/27/05, Brent Baisley <[EMAIL PROTECTED]> wrote:
> You would want to do a left join and only keep the null values.
>
> SELECT tableA.*
> FROM tableA
> LEFT JOIN tableB ON tableA.recordID=tableB.recordID
> WHERE tableB.rec
You would want to do a left join and only keep the null values.
SELECT tableA.*
FROM tableA
LEFT JOIN tableB ON tableA.recordID=tableB.recordID
WHERE tableB.recordID IS NULL
On Oct 27, 2005, at 6:35 AM, Christopher Molnar wrote:
If I have two similar tables, with identical columns how would I
If I have two similar tables, with identical columns how would I
select rows that are not duplicated between both tables? Any easy way
to do this?
Thanks,
-Chris
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PRO
