RE: off into the weeds

2003-11-28 Thread Bob Loeffler
Hi Dean, If I'm not mistaken, it looks like you are just joining the two tables (list_rank and entry) and not specifying which matching records you want (with a where... clause), so mysql is matching each row in one table with each row in the other table. That will be a HUGE result set, so it

Re: off into the weeds

2003-11-28 Thread Martijn Tonies
Hi Dean, I have populated the database, which has 6319 records in the list_rank table and 2472 records in the entry table. Everything looks fine, and I can easily do the simple queries such as: mysql select * from list_rank; However, when I run the following simple join, mysqld seems