Does anyone know how to create a workaround for the lack of unions in mysql? I've tried the temporary table route but I can't seem to create a temp table with cold fusion. I've tried CREATE TEMPORARY TABLE HOLD_TBL as Mysql suggests but cold fusion doesn't like it. Jeff ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

