Выборка нескольких записей из подчиненной таблицы с группировкой AND.

[sgt.Pepper]

SELECT * FROM InventTable
GROUP BY InventTable.RecId ASC,
InventTable.ItemId ASC,
InventTable.ItemName ASC,
InventTable.Intracode ASC,
InventTable.DiameterId ASC,
InventTable.WallThicknessId ASC
WHERE ((Dimension[5] = N'S0')) AND
((ChainType = 1)) AND ((PipeUnitId = N'mm'))
JOIN * FROM MaterialCollection
WHERE InventTable.ItemId = MaterialCollection.RefKey AND
InventTable.TableId = MaterialCollection.RefTableId AND
(((((MaterialCollection_1.CollectionId == "08X22H6T") || (MaterialCollection_1.CollectionId == "10G2FB")) || (MaterialCollection_1.CollectionId == "API 5L"))))