Post reply

Insert query

  • June 30, 2006 at 1:07 am

    #114157

    Can we use Where condition and Select statement in an INSERT statement? If so how can we do it? Thanks in advance.

    Mahathi.

  • June 30, 2006 at 1:20 am

    #646891

    What do you mean?

    You can do this

     

    Insert into Table (column1,column2....)

    select columna, columnb....

    Where [condition]

     

    Is this the answer that you were looking for?

    Claudia

  • June 30, 2006 at 1:45 am

    #646899

    Yes. Thank you for the reply given.

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

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