cros join

select p.nama, p.Jenkel, g.nama_jabatan from pegawai p left outer join golongann g on p.kd_jabatan = g.kd_jabatan

select p.nama, p.Jenkel, g.nama_jabatan from pegawai p right outer join golongann g on p.kd_jabatan = g.kd_jabatan

select p.nama, p.Jenkel, g.nama_jabatan from pegawai p full outer join golongann g on p.kd_jabatan = g.kd_jabatan

select p.nama, p.Jenkel, g.nama_jabatan from pegawai p inner join golongann g on p.kd_jabatan = g.kd_jabatan

Database Pegawai

create database kepegawaian

use kepegawaian

create table jabatan (

                kdjabatan char (4) not null primary key,

                namajabatan varchar (10))

select * from jabatan

insert into jabatan values ('1234','Direktur')

insert into jabatan values ('1235','manager')

insert into jabatan values ('1236','sekretaris')     

create table pegawai (

                NIP char (12) not null primary key,

                NAMA varchar (10),

                ALAMAT varchar (15),

                JNS_KLMN char (1),

                AGAMA varchar (10),

                kdjabatan char (4) references jabatan (kdjabatan))

select * from pegawai

insert into pegawai values ('201201030171','Dian','jln.karya','L','Islam','1234')

insert into pegawai values ('201201030177','Martin','jln.mangga','L','Kristen','1235')

 insert into pegawai values ('201201030175','Frans','jln.cebong','L','Kristen','1236')

select * from pegawai cross join jabatan