SQL Assistance

Results 1 to 2 of 2

Thread: SQL Assistance

  1. #1
    Join Date
    Dec 1969

    Default SQL Assistance

    I have an old table tbl_old with the following fields:<BR><BR>ColumnA, ColumnB, ColumnC<BR><BR>I have a new table tbl_new with the following fields:<BR><BR>ColumnA, ColumnC<BR><BR><BR>The matching fields in both tables are the same. I need to update the records in tbl_old FROM the matching records in tbl_new based on any matches happening in ColumnA from the 2 tables

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Assistance

    You&#039;d have to do something like...<BR><BR>UPDATE tbl_new<BR>SET ColumnB = SELECT ColumnB FROM tbl_old<BR>WHERE ColumnA = SELECT ColumnA FROM tbl_old<BR><BR>This help..?

Posting Permissions

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