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
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/mysql?
[EMAIL PROTECTED]
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]