tag:blogger.com,1999:blog-1281790217200500946.post9021147072724993314..comments2009-05-29T01:54:03.435-07:00Comments on Home of the SQL and MySql Resources: How to insert records from te one table to another table in SQLRRavehttp://www.blogger.com/profile/02162942492813501463noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1281790217200500946.post-54015797528624843552009-05-29T01:54:03.435-07:002009-05-29T01:54:03.435-07:00If you want to create a temporary table which cont...If you want to create a temporary table which contains few records from another table, you can create and insert the records in one step as below.<br /><br />create table aa_tmp AS<br />select *<br />from inventory_part_tab<br />where contract = 'A-S1';Aaruranhttps://www.blogger.com/profile/15617249087658261491noreply@blogger.com