Can you please send the tables structure. This happens when the fields you are using in the JOIN clause are with different types fro example when trying to join a VARCHAR with INT
Dobromir Velev [EMAIL PROTECTED] ----- Original Message ----- From: "Koen Van Mulders" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 16:54 Subject: Problem with EQ_REF and ALL I think they are all indexed, yes. I have an index on : bb.ver_id b.batch_bestel_id k.klant_id (k1 is the same) b.batch_lever_id l.ver_lev_id Tnx in advance -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]