The reason you did not get any error messages is because your query is not incorrect. It is good. But, it only selects records. It does not copy them into another table.
You need to add on to your sql command.
See this link and look at the part about how do you insert records in a table - see the part on copy data from one table to another:
http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=27[
^]