SQLite Forum

How to create a table as the union of two tables?
Login
why not simply:

```
CREATE TABLE tempunion AS SELECT * FROM tab1 UNION SELECT * FROM tab2;
```

or have I overlooked a problem with that?