Update cloud table from SQL query?

I need to update my revenue_line_items table to set the Manufacturer_ID, Category_ID and Type_ID fields with the corresponding values from the appropriate record in the product_templates table.  I downloaded a backup instance from the cloud and imported into a local MySQL server to test the queries and they work fine.  Unfortunately it appears that the syntax of the queries is not supported in the tools I have available to work with the cloud tables.  

I have been using the Skyvia web service to access the cloud data, and have also tried the Advanced Queries in Sugar itself.  

This is the query I am trying to run, modified for Category and Type....  I believe that the JOIN in the issue.  

UPDATE revenue_line_items R
JOIN product_templates T ON R.product_template_id = T.id
SET R.manufacturer_id = T.manufacturer_id
WHERE R.manufacturer_id IS NULL

Any ideas would be appreciated.  Different tool, revised query, etc.

Thanks

Parents Reply Children
No Data