Re: INSERT INTO FROM same table failing

Ramesh [EMAIL PROTECTED] wrote: In mysql 4.014, the below INSERT statement works fine: INSERT INTO TEST_TABLE SELECT 20, name FROM TEST_TABLE WHERE id = 10 But in mysql 4.1, it fails, I get a message: Error Code : 1066 Not unique table/alias: 'TEST_TABLE' (10 ms taken) Question: Is

INSERT INTO FROM same table failing

Hi, In mysql 4.014, the below INSERT statement works fine: INSERT INTO TEST_TABLE SELECT 20, name FROM TEST_TABLE WHERE id = 10 But in mysql 4.1, it fails, I get a message: Error Code : 1066 Not unique table/alias: 'TEST_TABLE' (10 ms taken) Question: Is this a problem with 4.1 or is it