I am trying to update a table with info from another table and also set two fields with the same info for each field. The first field productid will need to be inserted into the producttaxrel table with the contents of the same field in the products table.
Here's my query:
Update communiq_test.vtiger_producttaxrel T, communiq_test.vtiger_products P SET T.productid = P.productid,T.taxid=2, T.taxpercentage=6
The query comes back with 0 rows affected.
Comments as to why this won't work?
Thanks
Here's my query:
Update communiq_test.vtiger_producttaxrel T, communiq_test.vtiger_products P SET T.productid = P.productid,T.taxid=2, T.taxpercentage=6
The query comes back with 0 rows affected.
Comments as to why this won't work?
Thanks