Hi, MySql 4.0.14 How can I force the following query to use a reference in table1.
select * from table1 a left join table2 b on (a.field1 = b.field1) order by b.field2 limit 1 both a.field1 and b.field1 have indexes. Explaining the command indicates that, MySql uses an index (possible_keys) on table2 but All on table1. Is this how it should be? regards Send instant messages to your online friends http://uk.messenger.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]