Database - Relasi dengan WHERE

Langkah 1 :

create database kuliah;
use kuliah;
create table mahasiswa(nim char(15) not null primary key, nama varchar(20), alamat varchar(30),
kota varchar(20), kode_pos char(10), mk char(10));
select*from mahasiswa;
insert into mahasiswa values('1001530149','Ayu Kusumaningtyas', 'Gedawang','Semarang','50266','APS'),
('1001530150','Asthi Yantoro', 'Ungaran','Semarang','50267','RPL'),

('1001530148','Ngesti Purbo Jati', 'Gombel lama','Semarang','50261','APS'),
('1001530198','Tri Istiani', 'Gedawang','Semarang','50266','APS'),
('1001530205','Elsy Sasriani T', 'Klipang','Semarang','50236','RPL');

create table dosen(nip char(10) not null primary key, nama varchar(20), alamat varchar(30),
kode_pos char(10), mk char(10));
select*from dosen;
insert into dosen values('147888','Edy Winarno','Klipang','51245','APS'),
('1578412','Widiyatmoko Tri H','Ungaran','505325','RPL');

Langkah 2 :

select mahasiswa.nim, mahasiswa.nama, mahasiswa.mk, dosen.nama from mahasiswa,dosen where mahasiswa.mk=dosen.mk;