dognobbler
Programmer
I have two tables "profile" and "photovote" both of which have a column named "username". I want to copy the value of "username" from "profile" to "photovote" (which is currently empty.
I have tried doing
insert into photovote (username) values (select username from profile);
But this didn't work. Can anyone tell me how to do this.
Cheers
Andy
I have tried doing
insert into photovote (username) values (select username from profile);
But this didn't work. Can anyone tell me how to do this.
Cheers
Andy