databases rental dvd (join where)

create database rental;
use rental;
create table pegawai (id_pegawai varchar (5) primary key, alamat text, no_telepon varchar (12));
insert into pegawai values ('A0001','jl.bangkong','085727044697'),
('A0002','jl.peterongan','085123456789'),
('A0003','jl.pedurungan','085741373940');
select * from pegawai;

create table dvd (id_dvd varchar (4) primary key, nama_film varchar (20));
insert into dvd values ('D001','tali pocong perawan'),
('D002','namaku dick'),
('D003','sherlock holmes'),
('D004','ninja asasins');
select * from dvd;

create table pelanggan (id_pelanggan varchar (5),id_dvd varchar (4), nama varchar (20), alamat text);
insert into pelanggan values ('P0001','D001','congek','jl.gunungpati'),
('P0002','D002','adeseptiann','jl.muse'),
('P0003','D003','imam','jl.ndaun'),
('P0004','D004','nova','jl.terongan'),
('P0005','D002','rival','jl.telogosari');
select * from pelanggan;



select dvd.id_dvd, dvd.nama_film, pelanggan.id_pelanggan, pelanggan.id_dvd, pelanggan.nama, pelanggan.alamat from dvd, pelanggan where dvd.id_dvd=pelanggan.id_dvd;