WarehouseStockLevelsView
を入力します。SELECT
Warehouses.Warehouse_id,
Warehouses.Warehouse_Name,
WarehouseStockLevels.Product_Id,
WarehouseStockLevels.Quantity_On_Hand
FROM
WAREHOUSES Warehouses,
Warehouse_Stock_Levels WarehouseStockLevels
WHERE
Warehouses.warehouse_id = WarehouseStockLevels.warehouse_id
Copyright © 1997, 2009, Oracle. All rights reserved.