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/']
Assuming you have knowledge in Redux with React.

Firstly, install these packages

`$ npm install next-redux-wrapper react-redux redux redux-thunk --save`

`$ npm install redux-devtools-extension --save-dev`

---

Override or create the default App, create the file `./pages/_app.js` as shown below:

```js
import withRedux from 'next-redux-wrapper'
import { Provider } from 'react-redux'
import { withRouter } from 'next/router'
import App from 'next/app'

import createStore from 'store/createStore'

class MyApp extends App {
  render () {
    const { Component, pageProps, router, store } = this.props
    return (
          <Provider store={store}>
              <Component router={router} {...pageProps} />
          </Provider>
    )
  }
}

export default withRedux(createStore)(
  withRouter(MyApp)
)

```

---

In your pages/component, you can use Redux as you do normally.
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...