How do I save a query result to a new table?

[Merio]

I want to save a query result to a new table. Is this possible using sql commands? Like: Select Col1, Col2, Col7 from tbl1 Order by Col1 - Save it to tbl2 using the same column headers generated from the query?

Thanks!

[iburyak]

If you want to save select statement into a new table which will be created on a fly do following:

[PHP]Select Col1, Col2, Col7 into tbl2 from tbl1 Order by Col1 [/PHP]

If you want to insert select statement into existing table do following:

[PHP]Insert into tbl2
Select Col1, Col2, Col7 from tbl1 Order by Col1 [/PHP]

Good Luck.

[Merio]

If you want to save select statement into a new table which will be created on a fly do following:

[PHP]Select Col1, Col2, Col7 into tbl2 from tbl1 Order by Col1 [/PHP]

If you want to insert select statement into existing table do following:

[PHP]Insert into tbl2
Select Col1, Col2, Col7 from tbl1 Order by Col1 [/PHP]

Good Luck.

---
It worked. Thanks a lot!