List:General Discussion« Previous MessageNext Message »
From:sheeri kritzer Date:October 27 2005 8:23pm
Subject:Re: comparing two tables
View as plain text  
Oops, you are correct.  I missed a "not" in the original post.

-Sheeri

On 10/27/05, Brent Baisley <brent@stripped> 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?
> > unsub=brent@stripped
> >
> >
> >
>
> --
> 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/mysql?unsub=1
>
>
Thread
comparing two tablesChristopher Molnar27 Oct
  • Re: comparing two tablesBrent Baisley27 Oct
    • Re: comparing two tablessheeri kritzer27 Oct