materi join

create table Pembelian

(no_nota varchar(10) primary key,

kdbrg varchar(10) foreign key references Barang,

kdsup varchar(10) foreign key references supplier,

tglbeli date,

jlmbeli int,

hargabeli int,

total int

)

select * from Pembelian

insert into Pembelian values ('HG001','001','Sup006','2017/01/03',200,2000,400000)

insert into Pembelian values ('HG002','004','Sup002','2017/01/02',150,3000,450000)

insert into Pembelian values ('HG003','005','Sup001','2017/01/02',300,4000,1200000)

insert into Pembelian values ('HG004','002','Sup003','2017/02/10',200,5000,1000000)

insert into Pembelian values ('HG005','003','Sup008','2017/08/24',100,2500,250000)

insert into Pembelian values ('HG006','005','Sup004','2017/04/10',250,2000,500000)

insert into Pembelian values ('HG007','001','Sup007','2017/10/12',350,2000,700000)

insert into Pembelian values ('HG008','004','Sup005','2017/08/31',400,2000,800000)

insert into Pembelian values ('HG009','002','Sup001','2017/04/06',150,4000,600000)

insert into Pembelian values ('HG010','003','Sup003','2017/02/03',300,4000,1200000)