INNER JOIN across multiple tables appear very slow.

[sam wun]

Hi,
Can anyone tell me how to optimize the following sql statement?
$sql_1 = " SELECT t.prodcode 'Product Code',
                       t.prodname 'Product Name',
                       ROUND(avg(t.salesvolume),2) 'PastSales Quantity',
                       ROUND(avg(tt.salesvolume),2) 'Sales Quantity',
                       ROUND(avg(t.netsales),2) 'PastSales',
                       ROUND(avg(tt.netsales),2) 'Sales',
                       Round(((avg(t.netsales) - 
avg(tt.netsales))/avg(tt.netsales))*100,2) 'SalesDiff',
                       Round(((avg(t.salesvolume) - 
avg(tt.salesvolume))/avg(tt.salesvolume))*100,2) 'QtyDiff'
                       from customer c
               INNER JOIN transaction t
                       ON c.custcode = t.custcode
                       AND date(t.date) >= '$past_date_period_startdate'
                       AND date(t.date) <= '$past_date_period_enddate'
                       AND c.salescode = '$salescode_param'
               INNER JOIN transaction tt
                       ON c.custcode = tt.custcode
                       AND date(tt.date) >= '$input_date_period_startdate'
                       AND date(tt.date) <= '$input_date_period_enddate'
                       AND c.salescode = '$salescode_param'
                       AND t.prodcode = tt.prodcode
               INNER JOIN inventory i
                       ON i.prodcode = t.prodcode
                       AND i.prodcode = tt.prodcode
                       AND i.basename = '$basename_param'
               WHERE i.prodname is not NULL
                       and i.basename is not NULL
                 GROUP BY c.salescode, i.basename, t.prodcode
                 ORDER BY SalesDiff desc;

Thanks
Sam
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]