MySQL :: INSERT ... SELECT

I am embarassed to be asking this question but it has been a while since I worked with MySQL. I want to generate a table based on the criteria of a second. Here is what I would like to do but I know the syntax is incorrect and may require a JOIN command:

forums.mysql.com