Query to new table SQLite

the following query returns results successfully using the only two tables in by database. I'm having problems directing the results to create a new table.

    select Object.Xref, Object.area, Object.screen, Object.field, locator.data insert into Results from Object inner join locator on Object.area = locator.area and Object.screen = locator.screen and Object.field = locator.field      

I get the following error: "near "insert": syntax error:"

If I take the insert out. it works fine.