You cold use temp tables? Simon
-----Original Message----- From: amit lonkar [mailto:[EMAIL PROTECTED]] Sent: 07 January 2002 10:08 To: [EMAIL PROTECTED] Subject: URGENT HI!!! I am trying to execute the following query, in which i am tring to insert data from the table testtable into the same table testtable. insert into testtable(col1,col2) select col1.col2 from testtable; This query does not execute and generatethe following error:- Not Unique table/alias: 'testtable' Please do reply This is urgent Thanks Amit Lonkar --------------------------------------------------------------------- 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