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
