Добрый день.
Есть запрос, который в режиме дизайнера SQL работает без ошибок, но как только я его сохраняю как вьюшку, закрываю и открываю эту вьюшку, то вылазит ошибка Join expression not supported. (Error 3296)
Получается, что Access каким-то образом форматирует и убирает скобки?

SELECT DISTINCT
*
FROM ((((((((tbl_ref_Countries 
RIGHT JOIN (tbl_ref_Producers 
RIGHT JOIN ((h_tbl_Material 
INNER JOIN vw_MaterialStatus ON h_tbl_Material.MCode = vw_MaterialStatus.MCode) 
LEFT JOIN 
tbl_ref_Suppliers ON h_tbl_Material.SupplierID = tbl_ref_Suppliers.SupplierId) ON tbl_ref_Producers.ProducerId = h_tbl_Material.ProducerId) ON tbl_ref_Countries.CountryId = tbl_ref_Producers.CountryId) 
LEFT JOIN 
vw_MaterialPalletizing_Unit_Case ON h_tbl_Material.MCode = vw_MaterialPalletizing_Unit_Case.MCode
) 
LEFT JOIN 
vw_KAListing_Short AS vwREALListing_Short ON (h_tbl_Material.MCode = vwREALListing_Short.UL_MCode AND 
						 vwREALListing_Short.KAId = 4
)) 
LEFT JOIN 
vw_KAListing_Short AS vwEKOListing_Short ON (h_tbl_Material.MCode = vwEKOListing_Short.UL_MCode AND 
                         vwEKOListing_Short.KAId = 8
))
LEFT JOIN 
vw_KAListing_Short AS vwKaravanListing_Short ON (h_tbl_Material.MCode = vwKaravanListing_Short.UL_MCode AND 
                         vwKaravanListing_Short.KAId = 7
))
LEFT JOIN 
vw_KAListing_Short AS vwMetroListing_Short ON (h_tbl_Material.MCode = vwMetroListing_Short.UL_MCode AND 
                         vwMetroListing_Short.KAId = 1
))
LEFT JOIN 
vw_KAListing_Short AS vwFozzyListing_Short ON (h_tbl_Material.MCode = vwFozzyListing_Short.UL_MCode AND 
                         vwFozzyListing_Short.KAId = 5
))
LEFT JOIN 
vw_KAListing_Short AS vwAuchanListing_Short ON (h_tbl_Material.MCode = vwAuchanListing_Short.UL_MCode AND 
                         vwAuchanListing_Short.KAId = 2
)) 
LEFT JOIN 
vw_KAListing_Short AS vwCosmoListing_Short ON (h_tbl_Material.MCode = vwCosmoListing_Short.UL_MCode AND 
                         vwCosmoListing_Short.KAId = 6
						 )

http://www.sql.ru/forum/1102321/join-expression-not-supported-error-3296