Показать сообщение отдельно
Старый 10.07.2009, 16:18   #5  
sgt.Pepper is offline
sgt.Pepper
Участник
Аватар для sgt.Pepper
 
43 / 15 (1) ++
Регистрация: 05.10.2007
Адрес: Германия
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"))))