SQL multirow data on one row

I almost never ask a question, so please be patient with me.

Example Orders table:

Example Inventory table:

In this example, each part in Inventory has 4 warehouse entries. The actual stock available, and the amount in Holding for other orders. If either warehouse (Atlanta or Chicago, NOT Hold) has more stock than Ord_Qty (but not combined), I would like to get following result given an Order_ID:

As a beginner I have not been able to replicate this result.
I have tried using DISTINCT, LEFT/INNER JOIN, CASE + EXISTS ect.
Could anyone help me out with this?

Example query:

SELECT DISTINCT
    Ord_Partno, Ord_UnitPrice, Ord_Qty, 
    () AS Atlanta, () AS Chicago, () AS InStock 
FROM 
    Orders 
INNER JOIN 
    Inventory ON Ord_Partno = Inv_Partno
WHERE
    Order_ID = 1658712 
    AND (Inv_Warehouse = "Atlanta" OR Inv_Warehouse = "Chicago")

>Solution :

SELECT 
    Ord_Partno, Ord_UnitPrice, Ord_Qty, 
    AtlantaInv.Stock AS Atlanta,
    ChicagoInv.Stock AS Chicago,
    case when (AtlantaInv.Stock >= Ord_Qty OR ChicagoInv.Stock >= Ord_Qty) then 'Yes' else 'No' end as InStock
FROM 
    Orders 
INNER JOIN 
    Inventory AS AtlantaInv ON Ord_Partno = AtlantaInv.Inv_Partno and AtlantaInv.Inv_Warehouse = "Atlanta"
INNER JOIN 
    Inventory AS ChicagoInv ON Ord_Partno = ChicagoInv.Inv_Partno and ChicagoInv.Inv_Warehouse = "Chicago"