Problem inserting into a table

  • 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?

  • 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)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply