SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table orders (Order_ID int, Ord_Partno varchar(50), Ord_UnitPrice float, Ord_Qty int);
insert into orders values(1658712,	'PN001',	1.20,	9);
insert into orders values(1658712,	'PN002',	2.40,	4);
insert into orders values(1658712,	'PN003',	1.40,	21);
insert into orders values(1658712,	'PN004',	1.10,	16);

create table Inventory(Inv_Partno varchar(50), Inv_Warehouse varchar(100), Stock int);
insert into Inventory values('PN001','Atlanta',	14);
insert into Inventory values('PN001','AtlantaHold',	0);
insert into Inventory values('PN001','Chicago',	7);
insert into Inventory values('PN001','ChicagoHold',	0);
insert into Inventory values('PN002','Atlanta',	5);
insert into Inventory values('PN002','AtlantaHold',	18);
insert into Inventory values('PN002','Chicago',	0);
insert into Inventory values('PN002','ChicagoHold',	0);
insert into Inventory values('PN003','Atlanta',	2);
insert into Inventory values('PN003','AtlantaHold',	43);
insert into Inventory values('PN003','Chicago',	19);
insert into Inventory values('PN003','ChicagoHold',	0);

16 rows affected

Ord_Partno	Ord_UnitPrice	Ord_Qty	Atlanta	Chicago	InStock
PN001	1.2	9	14	7	Yes
PN002	2.4	4	5	0	Yes
PN003	1.4	21	2	19	No
PN004	1.1	16	0	0	No