newbie join issue

[Edward Ritter]

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