Ошибка при выполнении запроса

SELECT Main_Table.Address, SUM(First_Table.Summ) AS [Сумма первой таблицы], SUM(Second_Table.Sum_Second) AS [Сумма второй таблицы]
FROM (Main_Table INNER JOIN First_Table ON Main_Table.id = First_Table.id_Main) INNER JOIN Second_Table ON Main_Table.id = Second_Table.id_Main
GROUP BY Main_Table.Address

SELECT Main_Table.Address, SUM(First_Table.Summ) AS [Сумма первой таблицы], SUM(Second_Table.Sum_Second) AS [Сумма второй таблицы]
FROM (Main_Table LEFT JOIN First_Table ON Main_Table.id = First_Table.id_Main) LEFT JOIN Second_Table ON Main_Table.id = Second_Table.id_Main
GROUP BY Main_Table.Address

SELECT Main.Address, SUM(FIRST.summa) AS S1, SUM(SECOND.sum_sec) AS S2
FROM (Main INNER JOIN FIRST ON Main.id=FIRST.id_Main) LEFT JOIN SECOND ON FIRST.Id=SECOND.id_main
GROUP BY Main.Address

--запрос под именем Query1:
SELECT Main.Address, SUM(FIRST.Summa) AS S1
FROM Main LEFT JOIN [FIRST] ON Main.id=FIRST.id_Main GROUP BY Main.Address;
 
--запрос под именем Query2:
SELECT Main.Address, SUM(SECOND.Sum_Sec) AS S2
FROM Main LEFT JOIN [SECOND] ON Main.id=SECOND.id_Main GROUP BY Main.Address;
 
--и объединяющий суммы запрос:
SELECT Query1.Address, Query1.S1, Query2.S2
FROM Query1, Query2 WHERE Query1.Address = Query2.Address