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