Results 1 to 27 of 27

Thread: Update query simple (beginner)

Threaded View

  1. May 29th, 2007, 04:08 AM #6
    gphillips
    gphillips is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Oct 2005
    Posts
    393

    Re: Update query simple (beginner)

    The two tables are BFCD_Designs and USER_DESIGN_IMPORT. However, its not working. Whats wrong?

    Code:
    UPDATE  [BFCD_Designs] SET [BFCD_Designs].EndDt = 29/05/2007
WHERE   [BFCD_Designs].DesignID IN (SELECT [BFCD_Designs] FROM [User_design_import])

    Its resulted in me updating all records in table but I have lost all my data. How do I get this back? I only wanted to updat the records where there was a match between designs - not every record in BFCD_DESIGNS.
    Last edited by gphillips; May 29th, 2007 at 04:34 AM.
    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


Click Here to Expand Forum to Full Width