Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: Update from two tables in Enterprise Manager

    I'm trying to write a query (in enterprise manager) that will update one table's column with data from another table's column. Yet I can't seem to do it!!! Enterprise Manager won't accept UPDATE.. FROM clause, and I dont know how to do it otherwise!

    Here is the structure:

    Table A: col a, col b, col c

    Table B: col A, col B, col C

    I would like to update A.b with the data from B.B for the records where A.c = B.c

    Can anyone help!?

    Thanks so much!

  2. #2
    Join Date
    Jul 2002
    Village, MD
    If you do not have QA, isql, osql - it is strange... You could try this trick: just create a job with your query and run it...

Posting Permissions

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