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.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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]