Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011
    Posts
    7

    Unanswered: UPDATE Table 1 from Table 2 with only new value

    Hi,

    then here is my conditions:

    1- Table 1 is old and need update and contains clients name

    2- Table 2 is new and contain table 1 clients name and new names also

    3- Table 2 will update Table 1 with new clients name only.


    How do I design the query, please ?

    Thanks

  2. #2
    Join Date
    Nov 2010
    Posts
    84
    3- Table 2 will Append Table 1 with new clients name only.

    INSERT INTO Table1 ( Table1Name )
    SELECT Table2.Table2Name
    FROM Table2 LEFT JOIN Table1 ON Table2.Table2Name = Table1.Table1Name
    WHERE (((Table1.Table1Name) Is Null));

  3. #3
    Join Date
    Aug 2011
    Posts
    7

    it's working

    Your code is just working perfectly !!!

    THANK YOU !!!

Posting Permissions

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