OE.BOMBAY INVENTORY (view)
wikibot[edit]
View | OE.BOMBAY_INVENTORY |
Source[edit]
CREATE OR REPLACE VIEW OE.BOMBAY_INVENTORY AS SELECT p.product_id , p.product_name , i.quantity_on_hand FROM inventories i , warehouses w , products p WHERE p.product_id = i.product_id AND i.warehouse_id = w.warehouse_id AND w.warehouse_name = 'Bombay'