databases rental mobil (join where)

create database Rental_Mobil_Argyan;
use Rental_mobil_Argyan;

create table tb_pegawai(id_pegawai char(4), nama_pegawai char(40), alamat_pegawai char(50), tgl_lahir date, jenis_kelamin char(1));
insert into tb_pegawai values('PW01','Sumanto','jalan banyak anak-anak No.25 kota.Semarang','1987-07-01','L'),
('PW02','Sarmini','jalan kecemplung jurang Kota.semarang','1988-03-22','P'),
('PW03','Parnomo','jalan 17+ kota.Semarang','1988-07-12','L');
desc tb_pegawai;
select * from tb_pegawai;


create table tb_mobil(id_mobil char(4) primary key, nama_mobil char(20), kondisi_mobil char(10), sewa_per_hari int(7));
insert into tb_mobil values('MB01','Avanza','Bagus','250.000'),
('MB02','APV','Bagus','200.000'),
('MB03','Xenia','Bagus','190.000');
desc tb_mobil;
select * from tb_mobil;

create table tb_sopir(ib_sopir char(4) primary key, id_mobil char(4), nama_sopir char(40), tgl_lahir_sopir date, jenis_kelamin char(1));
insert into tb_sopir values('SP01','MB01','Sukron','1980-06-22','L'),
('SP02','MB02','Sastro','1988-02-23','L'),
('SP03','MB03','Karyono','1987-03-26','L');
desc tb_sopir;
select * from tb_sopir;

create table tb_pelanggan(id_pegawai char(11) primary key, id_mobil char(4), nama_pelanggan char(40), alamat_pelanggan char(50), tgl_lahir_pelanggan date, jenis_kelamin char(1),status_pelanggan char(10));
insert into tb_pelanggan values('10015500073','MB01','Machrival Fidha H','Mranggen kota.Semarang','1980-07-21','L','Duda'),
('10015500075','MB02','Imam Nur Arif','jalan ambyar kota.Semarang','1990-07-06','L','Lajang'),
('10015500166','MB03','Gigih Aji','jalan tanda tanya kota.Kendal','1987-11-21','L','Menikah');
desc tb_pelanggan;
select * from tb_pelanggan;


select tb_mobil.nama_mobil, tb_mobil.kondisi_mobil, tb_mobil.sewa_per_hari,
tb_sopir.nama_sopir, tb_sopir.tgl_lahir_sopir, tb_sopir.jenis_kelamin,
tb_pelanggan.nama_pelanggan, tb_pelanggan.alamat_pelanggan, tb_pelanggan.tgl_lahir_pelanggan, tb_pelanggan.jenis_kelamin, tb_pelanggan.status_pelanggan
from tb_mobil,tb_sopir,tb_pelanggan where tb_mobil.id_mobil = tb_sopir.id_mobil and tb_mobil.id_mobil = tb_pelanggan.id_mobil;