Was trying to retrieve the stock quantity(quantity on hand) per warehouse using  PGAdmin:

SELECT stock_inventory_line.product_qty as Quantity, stock_inventory_line.product_code as "Product Code", stock_inventory_line.product_name as "Product Name", stock_warehouse.code as "Warehouse"
FROM stock_warehouse 
inner join stock_inventory_line on stock_inventory_line.location_id = stock_warehouse.lot_stock_id
order by stock_warehouse.code;

It is getting the data which is different from the one presented by Odoo. What have I missed?

Thanks