retreive and insert?

Results 1 to 2 of 2

Thread: retreive and insert?

  1. #1
    Join Date
    Dec 1969

    Default retreive and insert?

    Hi,<BR><BR>I need to retreive data from one table in the database and insert that data into another table. All this should happpen by the click of a button in the webpage.<BR>How can I do this?<BR><BR>Thanks,<BR>

  2. #2
    Join Date
    Dec 1969

    Default insert

    &nbsp;<BR> insert into TableA<BR> select colA,colB<BR> from TableB<BR> where blah blah blah<BR><BR> the select statement must have the same number<BR> of columns in it as TableA. If tableb doesn&#039;t<BR> have all the columns, fake it.<BR><BR> <BR> insert into TableA<BR> select colA,colB,&#039;bla blah blah&#039;,0,&#039;another column value&#039;<BR> from TableB<BR> where blah blah blah

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts