List:General Discussion« Previous MessageNext Message »
From:Edward Ritter Date:July 20 2004 3:45pm
Subject:newbie join issue
View as plain text  
I've got a task that's gonna require me to compare one table to another 
and remove the rows from the first table that are found in the second 
table that match email_address.

I'm running 4.0.20a-nt-log. The first table has 10 colomns and about 50K 
records, and the second table has 46 columns and has about 16K records.

I've attempted a number of selects that just sat and hung the computer. 
I know I must be doing something wrong. I figure I'll need to do a left 
join on it, but I've not had much experience with joins as such and I 
need a little assistance.

Can anyone help me work this out? If you need more info, let me know.

Ed
Thread
newbie join issueEdward Ritter20 Jul
  • Re: newbie join issueStefan Kuhn20 Jul
    • Re: newbie join issueEdward Ritter20 Jul
      • Re: newbie join issueGarth Webb20 Jul
        • Re: newbie join issueEdward Ritter20 Jul
          • Re: newbie join issueEdward Ritter20 Jul