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) > > Ques

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 supposed