insert into using result of a select
Posted by Pali (Pali), 25 February 2004Anyone,
Is there a way I can insert rows returned from a select query from a table into itself.
insert into tableA(field1, field2) values (select field1, field2 from tableA)
blatantly doesnt work, but you get what i'm trying to achieve?!
I want to try and avoid writing code to achieve this.
Posted by Pali (Pali), 25 February 2004I'm using cr1ppy 3.23. it's impossible to do this!
Sorry for the posting.
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: firstname.lastname@example.org • WEB: http://www.wellho.net • SKYPE: wellho