Re: Equijoin on non-equality barfs!

2004-06-02 Thread Egor Egorov
Mailing List Receiver <[EMAIL PROTECTED]> wrote: > mysql> select bademail.email from bademail,noemail where bademail.email <> > noemail.email; > > bademail has about 30,000 rows and noemail has 13,000. > > This, by the way, does a good job of bringing your system to its knees! > You need somet

Equijoin on non-equality barfs!

2004-06-01 Thread Mailing List Receiver
mysql> select bademail.email from bademail,noemail where bademail.email <> noemail.email; bademail has about 30,000 rows and noemail has 13,000. This, by the way, does a good job of bringing your system to its knees! Todd Merriman mailist @ toolz.com -- MySQL General Mailing List For list arc