I need to crreate trail balance from two table

Check this

;WITH OpeningBalance AS (
    SELECT
        tblAccounts.ACCTID,
        tblAccounts.ACCTNAME,
        SUM(CASE WHEN tblAccounts.ACCTTYPE = 'CREDIT' THEN tblAccounts.OpeningBalance ELSE 0 END) AS OpeningBalanceCredit,
        SUM(CASE WHEN tblAccounts.ACCTTYPE = 'DEBIT' THEN tblAccounts.OpeningBalance ELSE 0 END) AS OpeningBalanceDebit
    FROM
        tblAccounts
	WHERE 
		tblAccounts.Date BETWEEN '2023-04-01' AND '2023-04-05'
    GROUP BY
        tblAccounts.ACCTID,
        tblAccounts.ACCTNAME
), TransactionTotals AS (
    SELECT
        tblTransactions.AccNo,
        tblTransactions.AcctName,
        SUM(tblTransactions.CreditAmt) AS CreditTotal,
        SUM(tblTransactions.DebitAmt) AS DebitTotal
    FROM
        tblTransactions
	WHERE 
		tblTransactions.Date BETWEEN '2023-04-01' AND '2023-04-05'
    GROUP BY
        tblTransactions.AccNo,
        tblTransactions.AcctName
)
SELECT
    ob.ACCTNAME AS 'Account Name',
    ob.OpeningBalanceCredit AS 'Opening Balance (cr)',
    ob.OpeningBalanceDebit AS 'Opening Balance (dr)',
    COALESCE(tt.CreditTotal, 0) AS 'Credit(sum)',
    COALESCE(tt.DebitTotal, 0) AS 'Debit(sum)',
	CASE 
		WHEN ob.OpeningBalanceCredit = 0 THEN 0 
		ELSE ABS((COALESCE(ob.OpeningBalanceCredit, 0) + COALESCE(tt.CreditTotal, 0)) - (COALESCE(ob.OpeningBalanceDebit, 0) + COALESCE(tt.DebitTotal, 0)))
	END AS 'Closing Credit',
	CASE 
		WHEN ob.OpeningBalanceDebit = 0 THEN 0 
		ELSE ABS((COALESCE(ob.OpeningBalanceDebit, 0) + COALESCE(tt.DebitTotal, 0)) - (COALESCE(ob.OpeningBalanceCredit, 0) + COALESCE(tt.CreditTotal, 0)))
	END AS 'Closing Debit'
FROM
    OpeningBalance ob
LEFT JOIN
    TransactionTotals tt ON ob.ACCTID = tt.AccNo AND ob.ACCTNAME = tt.AcctName;