Results 1 to 2 of 2

Thread: SQL Update Statement

  1. 04-02-2003, 12:38 PM #1
    gowildcats777
    gowildcats777 is offline Registered User
    Join Date
    Apr 2003
    Posts
    1

    SQL Update Statement

    How can I update 2 fields from 2 different tables? If this isn't possilbe how else could I do it?
    Thx for your help.
    Reply With Quote Reply With Quote
  2. 04-02-2003, 04:23 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Are you using SQL Server?

    You can use

    update t set c1=t1.c1, c2 = t2.c2
    from t1, t2, t
    where ....
    http://databaseandstorage.blogspot.com
    http://gotodba.weebly.com
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules