SQL Query to get list of all users

[SnakeEaterITA]

Cool, thanks. but i just noticed YAAS doesn't support multi-user selection. I want to assign an award to all the users of the usergroup 2

the tables i have to work on are award_user.award_id and award_user.userid

the thing i want to reproduce is:

SELECT userid FROM user WHERE usergroupid = 2 AND PUT THE userid INTO award_user.userid ASSOCIATED WITH award_user.award_id = 14

(i have to give the award 14 to all the users of the group 2)

any idea?

thanks a lot!

EDIT: ok i managed to insert the userid, but now they show 0 in the award_id column. I have to change all the 0 to 14

INSERT INTO award_user(award_id)
VALUES (16) WHERE award_id=0

is not working

EDIT 2: ok, I had to use the UPDATE function!