UPDATE TblAccounting
SET entrydate = invoice.invoicedate
FROM TblAccounting
INNER JOIN invoice ON TblAccounting.voucherno = invoice.invno
WHERE TblAccounting.type = 'Sales';