Показать сообщение отдельно
Старый 05.11.2007, 13:51   #10  
Beast-L is offline
Beast-L
Участник
Аватар для Beast-L
 
104 / 21 (1) +++
Регистрация: 20.10.2006
Адрес: Киев
SELECT * FROM InventSum WHERE ((((AvailPhysical > 0)))) JOIN * FROM InventTable WHERE InventSum.ItemId = InventTable.ItemId JOIN * FROM InventDim WHERE InventSum.InventDimId = InventDim.inventDimId JOIN * FROM InventLocation WHERE InventDim.InventLocationId = InventLocation.InventLocationId AND ((InventLocationType_UAI = Автомобили))