-- apps_transaction.upCartOwnerV3 (PROCEDURE)
BEGIN
UPDATE apps_transaction.detail_cart_owner a
JOIN apps_transaction.header_cart_owner b ON a.CartID = b.CartID
SET a.CartProductQty = qty, a.LastUpdated = NOW(), b.LastUpdated = NOW(),a.UpdatedBy = updatedBy1
WHERE a.ProductID = productID1 AND a.CartID = cartid1; -- b.EntryID = updatedBy1;
END