----- Original Message ----- From: Dobromir Velev To: Koen Van Mulders ; [EMAIL PROTECTED] Sent: Thursday, December 18, 2003 3:14 PM Subject: Re: Problem with EQ_REF and ALL
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 help me... I have 2 queries (in the end I end up joining them with a LEFT JOIN, but they don't "work" properly) SELECT * FROM tbl_v_batch b LEFT JOIN tbl_v_levering l ON l.ver_lev_id = b.batch_lever_id LEFT JOIN tbl_klanten k ON k.klant_id = l.ver_lev_klant_id This one gives ALL on tbl_v_levering l SELECT * FROM tbl_v_batch b LEFT JOIN tbl_v_bestelbon bb ON bb.ver_id = b.batch_bestel_id LEFT JOIN tbl_klanten k1 ON k1.klant_id = bb.ver_klant_id This one, on the other hand is correct and gives EQ_REF ! How is this possible ? It is almost exactly the same table structure :s... Somebody please help.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]