Pure (My)SQL transformations
Assuming TABLE 2 already exists with id_org, id_club, and foo, just create the 'the_value' column and issue an UPDATE call using joins

See the UPDATE manual

UPDATE table1 t1, table2 t2 SET t2.the_value=t1.the_value 
WHERE t1.id_org = t2.id_org AND t1.id_club = t2.id_club