Hi All,
How can i update dh.amountdelivered with pl.deliveredamount
the select is working but when i am trying to Update then (single row subquery returns more than one Row)
Update deliveryhistory dk
set dk.amountdelivered = (select pl.deliveredamount
from packingnoteline pl, packingnote...