Newbie Q - How do you copy data from one table to another

[dognobbler]

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

 

[venur]

Hi,

You are searching in the wrong forum.

The answer for the questions is

insert into photovote (username) select username from profile;

This might help you..

Cheeers
-Venu

 

[dognobbler]

thanks

Andy