mysql help

[Daot Lagorille]

Hi gang,

Here is what I am trying to do:

Select a bunch of records from a mysql table, then insert those values as new records in the same table.

Here is the mySQL I am using to do this:

INSERT INTO this_table ( this_column, that_column, another_column)
SELECT this_column, that_column, another_column
FROM this_table
WHERE that_column
LIKE '%%this_value%%';

Here is the error I get:

Not unique table/alias: 'schedule_availappt'

Here is a picture of a kitty:

http://www3.sympatico.ca/k.renaud/photos_cat/moobealadytn.jpg

Any suggestions? The first correct answer wins a chance to poke this awful cat's fat gut.

[Paul Jr]

Sorry, I can't help you.
And it's just as well, because I try to aviod poking such things as kitties fat guts.

[Daot Lagorille]

Fair enough.

*grumbles, kicks dirt*