How to update column Based on joins in sql :-
UPDATE GeneralJournalAccountEntry
SET IS_ConsolidationMainAccount = '',
IS_ConsolidateAccountName = ''
FROM GeneralJournalAccountEntry AS GJAE
JOIN GeneralJournalEntry AS GJE
ON GJE.RecId = GJAE.GeneralJournalEntry
WHERE GJE.SubledgerVoucherDataAreaId = 'VN06'
and GJE.ACCOUNTINGDATE > '2025-01-01'
