I’m trying to get this UPDATE to work with the FROM below

/*--------------YOUR UPDATE ---------------*/ 

        UPDATE [Volusion_WCL_Categories]  
         SET [CategoryDescription] = convert(nvarchar(max),[CategoryDescription]) +'<tr><td>'+ [Volusion_Product_Attributes].[PTR_Thermal_DTTT] + '"</td><td>' + [Volusion_Product_Attributes].[PTR_Thermal_Print_Width]  
        + '''</td>      <td>' + [Volusion_Product_Attributes].[PTR_Thermal_DPI] + '</td><td>' + [Volusion_Product_Attributes].[PTR_Thermal_Connections] + '</td><td>' + [Volusion_Product_Attributes].[PTR_Thermal_Options] + '"</td><td>' + [Volusion_Product_Attributes].[PTR_Thermal_Options] + '</td><td>' + [Volusion_Product_Attributes].[PTR_Thermal_Options] + '</td>'+
                                        '<td><a href="/product-p/' + [Volusion_WCL_Products].[productcode] +'.htm">' + [Volusion_WCL_Products].[productcode] + '</a></td><td> 
                                                        Same Day Shipping On Orders Before 2:00pm CST</td><td> $' + CAST([Volusion_WCL_Products] .[productprice] AS VARCHAR) +  
                                                        '<br/>Per Carton</td><td><a class="myButton" href="/ShoppingCart.asp?ProductCode=' + [Volusion_WCL_Products].[productcode] + '" "="">Add To Cart</a></td></tr>' 



FROM
        [DistributorFeeds].[dbo].[Volusion_WCL_Categories] [Volusion_WCL_Categories] 
                INNER JOIN [DistributorFeeds].[dbo].[Volusion_WCL_Products] 
                [Volusion_WCL_Products] 
                ON [Volusion_WCL_Categories].[categoryid] = 
                        LEFT ([Volusion_WCL_Products].[categoryids] ,
                        3)      
                                INNER JOIN [DistributorFeeds].[dbo]. 
                                [Volusion_Product_Attributes] [Volusion_Product_Attributes] 
                                ON [Volusion_WCL_Products].[productcode] = 
                                [Volusion_Product_Attributes].[productcode] 
WHERE
        ([Volusion_WCL_Categories].[categoryid] = 136) OR
        ([Volusion_WCL_Categories].[categoryid] = 135) 
ORDER BY
        [Volusion_WCL_Products].[productcode] ASC