select won't use index

[damage damage]

Hi,
I have written an SELECT statement which is not using an index. The naming of the tables and databases is a little complicated but I will post the original statement (may be it is a naming problem?).

mysql> use foo;
Database changed
mysql> explain select * from pfl.files LEFT JOIN pfl ON pfl.file = pfl.files.name WHERE pfl.files.name = 'bash';
+----+-------------+-------+------+---------------+------+---------+-------+---------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+-------+---------+-------------+
| 1 | SIMPLE | files | ref | name | name | 767 | const | 7 | Using where |
| 1 | SIMPLE | pfl | ALL | NULL | NULL | NULL | NULL | 8921877 | |
+----+-------------+-------+------+---------------+------+---------+-------+---------+-------------+

The naming:
- pfl is a table in database foo
- this table has a field with the name "file" which is indexed
- pfl is also a database which contains the table files
- this table has a field with the name "name" which is indexed

So, why is mysql not using the index on the field foo.pfl.file?

greez
Damage