Thread: INSERT Rows where userid=(SELECT id FROM userinfo)
View Single Post
Old 10-09-2012, 04:05 PM   PM User | #7
guelphdad
Super Moderator


 
guelphdad's Avatar
 
Join Date: Mar 2006
Location: St. Catharines, Ontario Canada
Posts: 2,629
Thanks: 4
Thanked 147 Times in 138 Posts
guelphdad will become famous soon enoughguelphdad will become famous soon enough
Quote:
Originally Posted by JefferyJamison View Post
Hi ! INSERT INTO VotingSite (userid, VotingSiteType, active)
SELECT UID, 30, 1 FROM userinfo

I think this will work.
Yes that will work. If you read the thread closely, you'll see that solution was given and verified two weeks ago though.
guelphdad is offline   Reply With Quote