Mysql 4.0 - Select Max While Joining Some general info i wanted to know

[electron 0]

I got a solution using CREATE TEMPORARY TABLE to select MAX things out of a table in reference to a Category.Now i want to know that is this CREATE TEMPORARY TABLE available after MySQL 3.23 Server intensive.I checked it out on the MySQL Administrator software that monitors your MySQL Software and the Load was infact less.But do all the hosts support this.Xisto does but then too, do hosts keep this on or no.I need this for my script.