добрый день.
Есть такой запрос на SQL:

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

нужно было переписать его на 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 
		INNER JOIN h_tbl_Material ON tbl_ref_MaterialPaletizing.MCode = h_tbl_Material.MCode 
		UNION ALL
				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 
		
		LEFT JOIN h_tbl_Material ON tbl_ref_MaterialPaletizing.MCode = h_tbl_Material.MCode
				WHERE (((h_tbl_Material.MCode) Is Null))
		UNION ALL 
				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 
		RIGHT JOIN h_tbl_Material ON tbl_ref_MaterialPaletizing.MCode = h_tbl_Material.MCode
				WHERE (((tbl_ref_MaterialPaletizing.MCode) Is Null))

Подскажите, как добавить что бы показывали записи только где

tbl_ref_MaterialPaletizing.AltUnitOfMeasure = 'PC'

?

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