Can I join these queries into one query?

[Jimbo]

SELECT B.[AS OF DATE], B.[LENDING ACTIVITY GROUP], B.PORT,
A.[SYS CODE], A.[SumOfBANK BALANCE], B.[BANK BAL]

FROM (

SELECT [Changing Data].[AS OF DATE], [Non-Changing Data].
[LENDING ACTIVITY GROUP], [Non-Changing Data].PORTFOLIO,
[Non-Changing Data].[SYS CODE], Sum([Changing Data].[BANK
BALANCE]) AS [SumOfBANK BALANCE]
FROM [Non-Changing Data] INNER JOIN [Changing Data] ON
[Non-Changing Data].[ARRANGEMENT KEY] = [Changing Data].
[ARRANGEMENT KEY]
GROUP BY [Changing Data].[AS OF DATE], [Non-Changing Data].
[LENDING ACTIVITY GROUP], [Non-Changing Data].PORTFOLIO,
[Non-Changing Data].[SYS CODE]
HAVING ((([Changing Data].[AS OF DATE])=#7/31/2004#)) as A

RIGHT JOIN

SELECT [Changing Data].[AS OF DATE], [Non-Changing Data].
[LENDING ACTIVITY GROUP], [Non-Changing Data].PORTFOLIO,
Sum([Changing Data].[BANK BALANCE]) AS [BANK BAL]
FROM [Non-Changing Data] INNER JOIN [Changing Data] ON
[Non-Changing Data].[ARRANGEMENT KEY] = [Changing Data].
[ARRANGEMENT KEY]
GROUP BY [Changing Data].[AS OF DATE], [Non-Changing Data].
[LENDING ACTIVITY GROUP], [Non-Changing Data].PORTFOLIO
HAVING ((([Changing Data].[AS OF DATE])=#7/31/2004#)) as B

ON A.PORT = B.PORT;