#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2012
    Posts
    1
    Rep Power
    0

    Storing list of values which are returned by a select query?


    Hi,

    I have a requirement like getting list of values from one table and inserting them into another table.

    I have tried with sub querying but didn't worked out because the select query is returning multiple values.

    Can any one please suggest how to proceed further and the ways how can I write this requirement.

    Thanks
    Lakshmi
  2. #2
  3. Humble Learner
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2007
    Location
    Bangalore, India
    Posts
    280
    Rep Power
    120
    try this.

    insert into table2 (select * From tabel1 where .......);

    if required you also specify the desired list of columns.

IMN logo majestic logo threadwatch logo seochat tools logo