temp tables mysql OT

Hi gang: Another mysql question. I would like to create a temporary table to perform searches. From my main table, I need to exclude records that have certain fields that are null or empty; and then sort the final result. I've spent over an hour looking at "How do I set up a temporary table in MySQL?" questions via Google with little help. My eyes and brain are blurry -- giving it up for tonight. Anyone have a sample or a clear reference for me to review? Thanks in advance guys. Cheers, tedd PS: Watch someone (maybe everyone) jump on "This ain't a MySQL list." -- ------- http://sperling.com http://ancientstones.com http://earthstones.com