> I have populated the database, which has 6319 records in the list_rank
> and 2472 records in the entry table. Everything looks fine, and I can
> do the simple queries such as:
> mysql> select * from list_rank;
> However, when I run the following simple join, mysqld seems like its
Join? I don't see a JOIN in that particular query. So you're asking MySQL
to match every row in table LIST_RANK to every row in ENTRY... Quite
some rows (15620568)
> chess against a chess master. It went on for minutes until I aborted it.
> seems like it should have returned almost immediately. Can anyone point
> the error of my ways?
> mysql> select list_rank.category_id,entry.id,entry.title from
> order by entry.title;
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL