|
07.04.2006, 13:09 | #1 |
NavAx
|
Предлагаю присоединить BOM к InventTableModule
вот так: PHP код:
SELECT * FROM InventTable JOIN * FROM InventTableModule WHERE InventTable.ItemId = InventTableModule.ItemId AND ((ModuleType = Заказ)) NOTEXISTS JOIN * FROM BOM WHERE InventTableModule.ItemId = BOM.ItemId |
|
|
|