SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Thread: Join Update

Hybrid View

  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2004
    Location
    St. Paul
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Join Update

    Hello,
    I have 3 tables (employees, spouses, children) and I want to use one table (employees) to update the other 2. This is a one time query and I want the addresses of the spouses and children to match the employees.

    How would I write an update statement to do that (using ColdFusion and SQL Server 2000)?
    Thanks for your help.
    Ryan

  2. #2
    SitePoint Guru asterix's Avatar
    Join Date
    Jun 2003
    Posts
    847
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can not do this in one query.
    You can only update one table at a time.

    You would have to write a stored procedure.


Bookmarks

Posting Permissions

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