Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 213
  • Last Modified:

New tables

How do I insert existing data from different tables into a new table just created?  I've created a new table with columns based on data I want from different tables but I can't get the data to populate the new columns.
0
enzerj
Asked:
enzerj
1 Solution
 
MobiNet-caCommented:

Take a look at the Select Into style SQL statements .

http://www.w3schools.com/Sql/sql_select_into.asp
0
 
enzerjAuthor Commented:
Perfect!  Thank you!
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now