clear markdown compare help best fiddles feedback dbanow.uk
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2591665 fiddles created (45716 in the last week).

create table kebutuhan (id int, no varchar(50), nama_kebutuhan varchar(50), jumlah int); insert into kebutuhan values (151, '17717072', 'Pagar Panel MF', 10) , (152, 17717072, 'U 30.30.120 T3', 30); create table supply (id int, no varchar(50), nama_barang varchar(50), penyedia int); insert into supply values (1, '17717072', 'U 30.30.120 T3', 5);
 hidden batch(es)


SELECT k.nama_kebutuhan , SUM(k.jumlah) AS 'jumlah' , SUM(s.penyedia) AS 'jumlah2' FROM kebutuhan k LEFT JOIN supply s ON s.no=k.no AND k.nama_kebutuhan = s.nama_barang WHERE k.no = '17717072' GROUP BY k.nama_kebutuhan;
nama_kebutuhan jumlah jumlah2
Pagar Panel MF 10
U 30.30.120 T3 30 5
 hidden batch(es)