MS SQL Server Copy Field Data from Another Table without SELECT
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
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