skip to main | skip to sidebar

RockeTier Development Blog

Showing posts with label Join. Show all posts
Showing posts with label Join. Show all posts

Sunday, February 22, 2009

How to Implement a Join between 2 Tables in T-SQL/SQL Server UPDATE Statement

Thanks for WineIsGood:

UPDATE tblA
SET tblA.a_myField = tblB.b_newField
FROM tblA, tblB
WHERE tblA.a_b_id = tblB.b_id
Posted by RockeTier Develpment Team at 7:02 PM No comments:
Labels: Join, SQL Server, UPDATE
Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ▼  2009 (39)
    • ▼  July (6)
      • converting IP address to IP number
      • Vista Speech Regognition API
      • Walkthrough: Creating a Windows Service Applicatio...
      • Semicolon after the if statement
      • Copying Microsoft SQL table to MySQL
      • MySQL Memory Table Size
    • ►  June (7)
    • ►  May (3)
    • ►  April (2)
    • ►  March (7)
    • ►  February (9)
    • ►  January (5)
  • ►  2008 (1)
    • ►  December (1)

Contributors

  • Ilan Arbiv
  • Ilya Chernyakov
  • Olga
  • RockeTier Develpment Team
  • Romi Kuntsman
  • Shachar Zehavi