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