↓ Skip to Main Content

Blackcat Software

Main Navigation

  • Home
  • What We Offer
  • Products We Support
  • Contact Us

Category: SQL

MS SQL Server Copy Field Data from Another Table without SELECT

By Dave Posted on 24-Jan-2017 Posted in SQL No Comments Tagged with Another table, DATA, SELECT, SQL, SQL server, UPDATE

Had to try this without a SELECT statement. UPDATE Designs SET Designs.ParentCompanyName = C.CompanyName FROM Designs D INNER JOIN Customers AS C ON D.ParentCustomerID = C.CustomerID

© 2025 Blackcat Software | Powered by Responsive Theme