Всем привет, подправьте меня, где я ошибся?
есть запрос в SQL.
Скрин в приложении
Делаю его на Access но ошибка

SELECT        tbl_ref_MaterialPaletizing.MCode, tbl_ref_MaterialPaletizing.ZUN_per_AUoM, tbl_ref_MaterialPaletizing.AUoM_per_ZUN, 
 tbl_ref_MaterialPaletizing.Length, tbl_ref_MaterialPaletizing.Width, tbl_ref_MaterialPaletizing.Height, tbl_ref_MaterialPaletizing.Volume, 
 ISNULL(tbl_ref_MaterialPaletizing.CU_NetW_g, CDec(h_tbl_Material.CU_W_G)) AS CU_NetW_g, tbl_ref_MaterialPaletizing.GrossWeight, 
 tbl_ref_MaterialPaletizing.CU_Volume_ml, tbl_ref_MaterialPaletizing.EAN, tbl_ref_MaterialPaletizing.EANCathegory
FROM            ((tbl_ref_MaterialPaletizing FULL OUTER JOIN h_tbl_Material 
						 ON tbl_ref_MaterialPaletizing.MCode = h_tbl_Material.MCode)
						 FULL OUTER JOIN tbl_ref_Material 
						 ON tbl_ref_MaterialPaletizing.MCode = tbl_ref_Material.MCode)
WHERE        (tbl_ref_MaterialPaletizing.AltUnitOfMeasure = 'PC')

в Access делаю так:

SELECT tbl_ref_MaterialPaletizing.MCode
FROM ((tbl_ref_MaterialPaletizing INNER JOIN h_tbl_Material 
ON tbl_ref_MaterialPaletizing.MCode = h_tbl_Material.MCode)
INNER JOIN tbl_ref_Material 
ON tbl_ref_MaterialPaletizing.MCode = tbl_ref_Material.MCode)
Union
SELECT tbl_ref_MaterialPaletizing.MCode
FROM ((tbl_ref_MaterialPaletizing LEFT JOIN h_tbl_Material
ON tbl_ref_MaterialPaletizing.MCode = h_tbl_Material.MCode)
LEFT JOIN tbl_ref_Material 
ON tbl_ref_MaterialPaletizing.MCode = tbl_ref_Material.MCode)
Union
SELECT tbl_ref_MaterialPaletizing.MCode
FROM ((tbl_ref_MaterialPaletizing RIGHT JOIN h_tbl_Material
ON tbl_ref_MaterialPaletizing.MCode = h_tbl_Material.MCode)
RIGHT JOIN tbl_ref_Material 
ON tbl_ref_MaterialPaletizing.MCode = tbl_ref_Material.MCode)

http://www.sql.ru/forum/1114108/full-outer-join