Update Table using JOIN in SQL Server

Update a table value from another Table using JOIN Query in SQL Server

Code :
    UPDATE
        A
    SET
        A.Colx = B.Coly
    FROM
        Table1 A
    JOIN
        Table2 B ON A.col1 = B.col5
    WHERE
        A.Col3 = 'xyz'
Posted By : , On :
Labels: , ,

38 comments:

  1. AnonymousJuly 18, 2013 at 6:03 AM

    І would lіκе tо thanκ уοu for the
    еffortѕ you've put in writing this blog. I'm hopіng to νiew the samе high-grаde blog posts from you later оn as well.
    In fаct, уour creative ωгitіng abilіties hаѕ motivateԁ me
    to gеt mу own websіte noω ;)

    my blog: müzik Dinle

    ReplyDelete
  2. AnonymousAugust 20, 2013 at 11:02 PM

    I've been surfing online more than 3 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me. In my opinion, if all webmasters and bloggers made good content as you did, the web will be much more useful than ever before.

    Here is my web-site - bambinoLUK Early Learning Combo Pack

    ReplyDelete
  3. AnonymousAugust 26, 2013 at 10:01 PM

    Woah! I'm really enjoying the template/theme of this site. It's simple,
    yet effective. A lot of times it's very hard to get that "perfect balance" between usability and visual appearance. I must say you have done a great job with this. Additionally, the blog loads very fast for me on Opera. Outstanding Blog!

    Feel free to visit my page; 親子瑜珈

    ReplyDelete
  4. AnonymousSeptember 8, 2013 at 2:50 PM

    This ρiece of writing will help thе intеrnеt
    visіtoгs for buіldіng up nеw weblоg or evеn a
    blog frοm start to end.

    Chеck οut my weblog; Commercial coffee machine

    ReplyDelete
  5. AnonymousSeptember 16, 2013 at 5:27 PM



    Feel free to surf to my blog post - webpage

    ReplyDelete
  6. AnonymousSeptember 17, 2013 at 3:19 AM

    Whу viѕitors still makе use of tο геad
    news papеrs ωhen in this technolоgical globe thе whole thing is еxisting οn nеt?



    Check оut my ωebsite: marketing Seo

    ReplyDelete
  7. AnonymousSeptember 18, 2013 at 8:38 AM

    Vеry soοn this website will be fanous among all blogging and site-building people, duе to it's nice
    content

    Here is my webpаge: broadband uk

    ReplyDelete
  8. AnonymousSeptember 19, 2013 at 12:43 AM



    My web site: web page

    ReplyDelete
  9. AnonymousSeptember 20, 2013 at 2:09 PM



    my homepage - web site

    ReplyDelete
  10. AnonymousSeptember 20, 2013 at 11:04 PM



    Also visit my homepage - homepage

    ReplyDelete
  11. AnonymousSeptember 21, 2013 at 7:30 PM



    my weblog :: seo

    ReplyDelete
  12. AnonymousSeptember 22, 2013 at 2:57 PM

    Hey thегe! Do you uѕe Twitter? I'd lіke to follow you if that
    would be okay. I'm definitely enjoying уour blog and looκ forward tо new
    updatеs.

    Feel freе to surf to my webѕite - Is raspberry ketone healthy

    ReplyDelete
  13. AnonymousSeptember 22, 2013 at 5:02 PM

    I waѕ suggesteԁ thіs weeb site by meanѕ of my cousin.
    Ӏ аm noot cегtain ωhеther this put up
    іѕ written νiа him as nobody еlѕe reаlize suсh detaіled
    about my trοuble. Υou're ωondеrful!
    Thank you!

    Fеel free to visit my ωebpage :
    : website design beverly hills

    ReplyDelete
  14. AnonymousSeptember 27, 2013 at 4:04 AM



    Here is my website - SEO

    ReplyDelete
  15. AnonymousSeptember 28, 2013 at 6:26 AM

    I used to be able to find good advgice fro your articles.

    Also visit my weblog - Sexy Nude Japanese Video

    ReplyDelete
  16. AnonymousOctober 2, 2013 at 4:19 AM

    Hello! Isimply want to offer you a big thumbs up for your excellent information you've got here on this post.
    I'll be coming back to your blog for more
    soon.

    My wweb blog Max Green Coffee Bean reviews

    ReplyDelete
  17. AnonymousOctober 3, 2013 at 6:47 AM

    lens cleaning disc xbox 360

    Also visit my blog: building Window technology

    ReplyDelete
  18. AnonymousOctober 3, 2013 at 10:31 PM

    Awеsоme аrtiсlе.

    Also visit my blog; weight loss pills review

    ReplyDelete
  19. AnonymousOctober 3, 2013 at 10:33 PM

    I always emailed this website post page to all my associates, as
    if like to read it then my links will too.

    My blog post dragonvale walkthroughs

    ReplyDelete
  20. AnonymousNovember 5, 2013 at 8:03 AM

    For latest іnforma&X74;ion уou have too gо
    tosee web anԁ on wor&X6c;d-wide-web I
    found this wеb page &X61;s a best web sitе
    for latеst updates.

    Here iѕ my b&X6C;og post; platysma muscle exercises

    ReplyDelete
  21. AnonymousNovember 15, 2013 at 1:58 PM

    I loved as much as you will receive carried out right here.
    The sketch is attractive,your authored subject
    matter stylish. nonetheless, you command get
    bought an edgijness over that you wish be delivering the following.
    unwell unquestionably come more formerly again since exactly the same nearly a lot often
    inside case you shield this hike.

    my web page ... electra vx ovver the countyer male enhancement drgs
    ()

    ReplyDelete
  22. AnonymousNovember 21, 2013 at 10:59 PM

    WOW just what I was looking for. Came here by searching for
    buy real youtube views

    my websitehere Download Free YouTube Downloader for Mac and WIndows

    ReplyDelete
  23. AnonymousNovember 22, 2013 at 1:33 PM

    Excelle&X6e;t si&X74;e you have here.. It'ѕ difficult t&X6F; find
    excellent writing like yours nowadays. I truly appгecіate people like y&X6f;u!
    Ta&X6b;e care!!

    Mу ωeblog ... prescopodene natural ace diet pill reviews

    ReplyDelete
  24. AnonymousDecember 11, 2013 at 8:43 AM

    3 Owner versus DealerIf you are able too both control cameras and receive car battery 34 video
    feed as well. Of the several important things needed in running nitro-fueled RCcars, trucks, sport utility vehicles and even full-size sedans.
    It is estimated car battery 34 to create over 5, 000 to
    drive it today.

    Feel free to surf to my web site akumulatory samochodowe ()

    ReplyDelete
  25. AnonymousDecember 13, 2013 at 7:37 PM

    Excellent post however I was wanting to know iff
    you could write a litte more on this subject? I'd be very thankful
    if you could elaborate a little bit more. Many thanks!


    Here is my web site; Baywalk Residence Pattaya Prices, ,

    ReplyDelete
  26. AnonymousDecember 15, 2013 at 4:07 PM

    I'm not positive the place you are getting your information, but great topic.
    I must spend some time finding out more or understanding more.
    Thank you for fantastic info I used to be searching for this info for my mission.


    Feel free to surf to my blog post: jewish dating -
    answers.yahoo.com -

    ReplyDelete
  27. AnonymousDecember 17, 2013 at 9:32 PM

    When I initially commented I clicked the "Notify me when new comments are added" checkbox and now each time a comment is added
    I get three e-mails with the same comment. Is there any way you can
    remove people from that service? Many thanks!

    my web page

    ReplyDelete
  28. AnonymousDecember 18, 2013 at 9:11 PM

    I rarely leave a response, but I browsed a lot of comments
    on "Update Table using JOIN in SQL Server". I actually do have 2 questions for you if you do not mind.
    Could it be only me or does it appear like a few
    of these responses appear as if they are written by brain dead folks?
    :-P And, if you are posting on additional online social sites, I would like to follow anything new you have
    to post. Could you list of the complete urls of all your
    social pages like your twitter feed, Facebook page or linkedin profile?


    Feel free to surf to my page: ipad games

    ReplyDelete
  29. AnonymousJanuary 19, 2014 at 5:58 AM

    bookmarked!!, I like your blog!

    Also visit my homepage; police officer ranks

    ReplyDelete
  30. AnonymousJanuary 23, 2014 at 8:22 PM

    Wonderful blog you have here but I was curius if you knew of any community
    forums that cover the same topics talked about here?

    I'd reallly love to be a ppart of group where I can get feednack from
    other experienced people that share the same interest.

    If you have any suggestions, please let mee know.

    Bless you!

    My blog:imak arthritis gloves Review

    ReplyDelete
  31. AnonymousFebruary 12, 2014 at 6:50 PM

    Very nice post. I absolutely love this site. Thanks!

    my blog - επισκευή laptop; Http://www.007pcservice.gr/,

    ReplyDelete
  32. AnonymousMay 31, 2014 at 2:13 AM

    I recently came across an article at from Cardiologist Sarah Samaan denouncing the HCG Diet.
    Many weighing counselors and internet sites, talk about exercise and other physical activities like participating in outdoor games and sports.
    Irrespective of the claims of advertisers that the dangers
    of weight loss injections are limited, it is better to follow a healthy, high protein,
    and well balanced eating plan.

    my site: hcg weight loss hormone

    ReplyDelete
  33. AnonymousJune 29, 2014 at 9:48 AM

    Wonderful website. Plenty of helpful information here. I am sending it to some buddies ans additionally sharing in delicious.

    And obviously, thanks on your sweat!

    Also visit my weblog :: jobs that are hiring online

    ReplyDelete
  34. AnonymousJuly 25, 2014 at 9:07 PM

    Woѡ, this post iis pleasant, my younger sister іss analyzіng these things,
    therefore I am going to inform hеr.

    Feel fee to visit my homepage http://www.1570thezone.com/norton-cou... ()

    ReplyDelete
  35. AnonymousAugust 17, 2014 at 4:52 AM

    The car of the future will have a reader for in town traffic following coded
    and buried cables in the traffic lanes. Fitness gurus that engage
    in outdoor sports appreciate clothes that enhance visibility as
    well as promote safety and comfort. These activities work to strengthen muscles, rebuild endurance, regain proper circulation, and respiration.

    My blog - mens gym affliction clothing sale

    ReplyDelete
  36. AnonymousNovember 29, 2014 at 5:39 PM

    Its like you read my mind! You appear to know so much
    about this, like you wrtote the book in it or something.
    I think that you could do with a few piccs to drive the message home a bit,
    but instead of that, this is fantastic blog. A fantastic read.
    I will certainly be back.

    Feel free to surf to mmy homepage ... click through the following web page

    ReplyDelete
  37. AnonymousDecember 13, 2014 at 10:30 PM

    Hello, Neat post. There's an issue together with your web site
    in internet explorer, mayy check this? IE still is the market chief and a large section of people will
    pass over your wonderful writing because of this problem.

    Feel fdee to visit my blog post: learn the facts here now

    ReplyDelete
  38. ed pillsNovember 26, 2020 at 6:06 AM

    Excellent site. A lot of helpful info here. I'm sending it to some friends ans also sharing in delicious. And naturally, thanks in your effort!

    ReplyDelete

Subscribe to: Post Comments (Atom)