MySQL Cool requests

UPDATE
llx_facture a
INNER JOIN
(
SELECT fk_facture,
SUM(total_tva) AS vat,
SUM(total_ttc) AS ttc
FROM llx_facturedet
GROUP BY fk_facture
) b ON a.rowid = b.fk_facture
SET
a.tva = b.vat,
a.total_ttc = b.ttc

UPDATE Books, Orders
SET Orders.Quantity=Orders.Quantity+2,
Books.InStock=Books.InStock-2
WHERE Books.BookID=Orders.BookID
 AND Orders.OrderID = 1002;
 

UPDATE llx_propal, llx_propal_extrafields
SET llx_propal.ref_client = llx_propal_extrafields.description
WHERE llx_propal.rowid = llx_propal_extrafields.fk_object
AND ((ref_client = "") OR (ref_client IS NULL))
AND (llx_propal_extrafields.description IS NOT NULL)
AND (llx_propal_extrafields.description != "")