[SOLVED] using subquery to populate new table

[menriquez]

yes i am having a dumb issue on a easy problem.  all i want to do is take the email field from on table to create a user key field in another, so i am trying this...

 

INSERT INTO scores (user_id) 

select email from contestants;

 

i get a "duplicate key 0 in field 1" error, which means my select is return an integer and not the email string...whats up with that?

 

- mark

 

[menriquez]

oh never mind the used_id field was an integer not string...sorry

 

- mark