Re: Problem with EQ_REF and ALL

2003-12-23 Thread Dobromir Velev
Sent: Friday, December 19, 2003 13:52 Subject: Re: Problem with EQ_REF and ALL Hello, first of all, tnx for the great help so far ! I run MySQL 3.24. You say I have some duplicate indexes I didn't add KEY(klant_id) for instance, phpmyadmin did that :-s How do i drop the KEY but

Re: Problem with EQ_REF and ALL

2003-12-19 Thread Dobromir Velev
lev Sent: Thursday, December 18, 2003 17:52 Subject: Re: Problem with EQ_REF and ALL Please excuse me if this comes to your personal mailbox, i have no clue on how to use these lists :-) I am proud I could post my problem, I don't know how to reply to it :-(. Anyway, here are the

Re: Problem with EQ_REF and ALL

2003-12-18 Thread Dobromir Velev
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: <[EMA

Re: Problem with EQ_REF and ALL

2003-12-18 Thread Dobromir Velev
Hi, Have you indexed the fields you're using in the JOIN clauses? Dobromir Velev [EMAIL PROTECTED] - Original Message - From: "Koen Van Mulders" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 18, 2003 15:45 Subject: Problem with EQ_REF and ALL Someone please hel