I want to create a new table from query result in SSMS:

Query result:

```
select table1.col1, table1.col2, table2.col3
from table1
inner join table2 on table1.col1 = table2.col1
order by col1 asc;

```

How can I create new table from above result:

I have tried

```
select *
into new_table
from (
    select table1.col1, table1.col2, table2.col3
    from table1
    inner join table2 on table1.col1 = table2.col1
    order by col1 asc
);

```

I got the error

> 
> Msg 102, Level 15, State 1, Line 11 Incorrect syntax near ';'.
> 
> 
> 

Thanks
['https://Stackoverflow.com/questions/65421043', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/14875495/']
First i created simple next.js app with "npx create-next-app"
Then i installed "npm i redux react-redux redux-thunk redux-devtools-extension

Then I created general redux setup in a folder called "store" and folder structure is like the following image and code is for store.js

[![enter image description here](https://i.stack.imgur.com/Wr5XM.png)](https://i.stack.imgur.com/Wr5XM.png)

Code is for reducer > index.js
[![enter image description here](https://i.stack.imgur.com/dgEAv.png)](https://i.stack.imgur.com/dgEAv.png)

FINALLY created a \_app.js file in pages folder and code is like this
[![enter image description here](https://i.stack.imgur.com/VxhJh.png)](https://i.stack.imgur.com/VxhJh.png)

If anyone still have question about setup please let me know...
<https://github.com/vercel/next.js/tree/canary/examples/with-redux-wrapper>

cant get any easier than this