Untitled
raw download clone
TEXT
views 18
,
size 983 b
select biodata_pegawai.nip,biodata_pegawai.nama_lengkap,
biodata_pegawai.id_skpd,skpd.skpd from biodata_pegawai
INNER JOIN skpd ON biodata_pegawai.id_skpd = skpd.id_skpd

select biodata_pegawai.nip,biodata_pegawai.nama_lengkap,
	biodata_pegawai.id_skpd,skpd.skpd from biodata_pegawai
	inner join skpd ON biodata_pegawai.id_skpd = skpd.id_skpd

select biodata_pegawai.nip,biodata_pegawai.nama_lengkap,biodata_pegawai.id_skpd,skpd.skpd,biodata_pegawai.id_jabatan,jabatan.id_jabatan,biodata_pegawai.id_pangkat,pangkat.id_pangkat
	from biodata_pegawai
	inner join skpd ON biodata_pegawai.id_skpd=skpd.id_skpd
	inner join jabatan ON biodata_pegawai.id_jabatan=jabatan.id_jabatan
	inner join pangkat ON biodata_pegawai.id_pangkat=pangkat.id_pangkat

select biodata_pegawai.nip,biodata_pegawai.nama_lengkap,
	biodata_pegawai.id_skpd,skpd.skpd from biodata_pegawai
	inner join skpd ON biodata_pegawai.id_skpd = skpd.id_skpd

select *from biodata_pegawai cross join skpd
close fullscreen
Login or Register to edit or fork this paste. It's free.