By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table HPO(pono int,vendor varchar(100),status varchar(100))
insert into HPO values(123,'aaa','Approved'),
(321,'bbb','Approved'),
(456,'ccc','Pending'),
(654,'ddd','Draft')
create table HPODetails(pono int, totalprice double)
insert into HPODetails values(123,100.00),
(123,25.00),
(321,75.00),
(456,25.00),
(654,10.00),
(654,90.00)
create table vendor(vendorname varchar(100), vendorno int)
insert into vendor values('aaa',444),('bbb',555),('ccc',777)
SELECT A.pono,Vendor,Status, SUM(C.totalprice) as POTOTAL
FROM HPO A
INNER JOIN vendor B on A.vendor = B.vendorname
INNER JOIN HPODetails C on A.pono = C.pono
GROUP BY A.pono,Vendor,Status
| PONO | VENDOR | STATUS | POTOTAL |
|---|---|---|---|
| 123 | aaa | Approved | 125 |
| 321 | bbb | Approved | 75 |
| 456 | ccc | Pending | 25 |