Anyone know why this query takes so long? SELECT SUM(l.cost+l.fscc) FROM orders o, acctg.invoice i LEFT JOIN acctg.payable p ON (o.ORD_NO=p.ORD_NO) WHERE p.ORD_NO IS NULL AND i.ORD_NO=o.ORD_NO;
Is there something I can do to speed it up? Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]