How to create a table from previously loaded table

[alandilworth]

Hello, I am trying to create a new table with data pulled from another existing table in the data model.  I have a table named AllTimeMega that has already  been loaded to the data model.  I am now trying to create a new table named BestMonthSales that contains certain fields from AllTimeMega.  Seems like a pretty straightforward task but I keep getting field not recognized errors for each of the fields.  I have researched this a lot and have no idea what I am doing wrong.  My script is below.  Any insight will be greatly appreciated.

[Or · Accepted solution]

Load Field1, Field2, Field3

Resident Table1;

That extra select is getting in the way, I think.

[alandilworth]

I'm still getting field not found for 'Month'

EDIT:  Disregard that fixed the problem.  Thanks!