You can do this. On the screen titled "Specify Table Copy or Query", choose "Write a query to specify the data to transfer". In the next screen, paste your query.