Hi, SELECT A.fld1, A.fld2, B.fld1 FROM A LEFT JOIN B ON A.lnkfld = B.lnkfld LIMIT 100;
A and B are big table and this command is very slow. If I use INNER JOIN, is very fast but I loose some records. How I can write a faster LEFT JOIN command? Thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]