Problem inserting into a table

• senicachisolm

  Grasshopper

  Points: 23

  More actions

  May 2, 2002 at 8:26 am

  #57963

  I want to insert data from 2 tables into a 3rd table. Here's an example.

  insert into Table3(n1,n2,n3)

  values ('jack','mary','billy')

  insert into Table3

  select * from Table1 where city='charlotte'

  ====

  How do I combine these two insert statements into one?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  May 2, 2002 at 9:22 am

  #428322

  Cannot join these 2 INSERTS into 1. Have to run seperately. Unless you try a union query with the values to table1.

  SELECT 'jack','mary','billy'

  UNION ALL

  select * from Table1 where city='charlotte'

  but this will take some work to make sure looks right. What exactly do you need to do?

  "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)