coba bantu
SELECT a.nip, a.nama, b.indek AS lama, c.indek AS baru, a.gaji_b from tb_pegawai a,tb_gaji b,tb_gaji c where a.nip='1111' and ((b.gajimin <= a.gaji_l and a.gaji_l <= b.gajimak) and (b.jabatan = a.jab_l or a.jab_l='')) and (c.gajimin < a.gaji_b and a.gaji_b <= c.gajimak) and c.jabatan = a.jab_b coba kaya gini, bener ga hasilnya seperti yg dimaksud, aku cuma ganti < jadi <= , trus ngapus "a.jab_l=b.jabatan" --- On Wed, 25/8/10, Itsnasov Mc Rodsky <[email protected]> wrote: From: Itsnasov Mc Rodsky <[email protected]> Subject: [indo-oracle] Query menampilkan indek gaji lama & baru To: [email protected] Date: Wednesday, 25 August, 2010, 13:58 ups... maaf kepencet tadi. Dear all, saya ada 2 table sbb : 1. tb_pegawai NIP NAMA JAB_L GAJI_L JAB_B GAJI_B 1111 AAA 0 STA 500000 (ket. peg. baru) 2222 BBB STA 100000 SPV 1500000 2. tb_gaji INDEK JABATAN GAJIMIN GAJIMAK 01 STA 0 500000 02 STA 500001 1000000 03 STA 1000001 1500000 04 SPV 500001 1000000 05 SPV 1000001 1500000 saya lakukan query sbb : select a.nip,a.nama,b.indek lama,c.indek baru from tb_pegawai a,tb_gaji b, tb_gaji c where a.nip='2222' and a.jab_l=b.jabatan and ((b.gajimin < a.gaji_l and a.gaji_l <= b.gajimak) and (b.jabatan = a.jab_l or a.jab_l='')) and (c.gajimin < a.gaji_b and a.gaji_b <= c.gajimak) and c.jabatan = a.jab_b hasilnya : 2222 BBB 01 05 masalahnya saat saya query dengan NIP = 1111 data tidak tampil, karena pegawai 1111 adalah pegawai baru sehingga jabatan lama tidak ada. Gimana solusinya. Terimakasih sebelumnya Itsna [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
