SELECT * FROM branches WHERE id=(SELECT BranchId FROM Stocks WHERE StockId=1)