I'm using version 3.23.25, and am having trouble setting up a temporary table. I have the following permanent table already set up: bill_pay (pbid int (8) default '0' not null auto_increment, billdesc varchar(20), bpamount int(8), pbdate date, budgetid int(8), primary key (pbid), unique id (pbid)) I have tried to set up a temporary table: CREATE TEMPORARY TABLE tempbills ( billdesc varchar(20), bpamount int(8) ) SELECT billdesc, bpamount FROM bill_pay When I do this I get an error message saying "Duplicate column name "billdesc"". And if I change the column names on the temp table it still won't work - the table doesn't get created. If someone could help me out I'd be grateful! Matt _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
