Temp tables

[Erich C. Beyrent]

Hi all,

I am running into a brick wall with a query that is running against a 
MySQL 3x database, and the temp tables are filling up before the query 
can run.

Here is the query:

SELECT
    Avails.ResortID,
    Inventory.ID as InventoryID,
    Avails.ID as AvailabilityID,
    DATE_FORMAT(Avails.OpenWhen, '%c/%d/%Y') as OpenWhen,
    Avails.Cost,
    Inventory.Name,
    Inventory.Capacity,
    Inventory.Beds,
    Inventory.Baths,
    ResortSpecials.RequiresTour
FROM
    Inventory,
    Avails,
    ResortSpecials
WHERE
    Avails.InvID = Inventory.ID AND
    Inventory.Activated = 'Y' AND
    Inventory.PromotionID = ResortSpecials.ID AND
    ResortSpecials.RequiresTour = 'N' AND
    Avails.OpenWhen > NOW() AND
           (Avails.StatusCode = 'GREEN' OR
            Avails.StatusCode = 'YELLOW')
ORDER BY
           Avails.ResortID,
          Avails.InvID,
           Avails.OpenWhen;



Is there anything I can do to get this query to run - is there a size 
limit for the temp tables that can be tweaked?

I am sure I can do the sorting in PHP if that will help the situation...

-Erich-

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