Terima kasih atas jawabannya
-----Original Message----- From: Purwedi Kurniawan <[EMAIL PROTECTED]> To: [email protected] Date: Wed, 7 Sep 2005 11:07:52 +0800 Subject: Re: [Programmer-VB] QueRY Access > cuman mau nambahin tanggapannya mas dyaz > > kalau mau lebih cepat, coba gunakan distinct di subquerynya > > > select NO_KRS, Nim from TBL001 where TBL001.No_KRS not in (select > DISTINCT no_KRS > > from TBL002) > > trus mungkin mas aji sudah tidak perlu menyebutkan field nim di TBL002 > karena sudah ada di table TBL001 (ini hanya kalau normalisasi data > dianggap perlu ya :P ) > > rgds > [wwn] > > On 9/6/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Dear All, > > > > > > Mohon bantuannya para master, saya punya 2 buah table sbb : > > > > > > TBL001(Ambil KRS) > > > No. KRS Nim Nama > > > ---------------------------- > > > 0000000001 0311510022 A > > > 0000000002 0311510023 B > > > 0000000003 0311510024 C > > > 0000000004 0311510025 D > > > 0000000005 0311510026 E > > > 0000000006 0311510027 F > > > > > > TBL002(List Detail Registrasi KRS) > > > No. KRS Nim KDMtkuliah > > > -------------------------------- > > > 0000000001 0311510022 GD001 > > > 0000000001 0311510022 GD002 > > > 0000000001 0311510022 GD003 > > > 0000000001 0311510022 GD004 > > > 0000000002 0311510023 GD001 > > > 0000000002 0311510023 GD002 > > > 0000000002 0311510023 GD003 > > > 0000000002 0311510023 GD004 > > > > > > -------------------------------------Nah dari ke-2 tabel di atas > saya > > > ingin > > > menghasilkan Query sbb : > > > > > > No. KRS Nim > > > ------------------------ > > > 0000000003 0311510024 > > > 0000000004 0311510025 > > > 0000000005 0311510026 > > > 0000000006 0311510027 > > > > > > Maksudnya supaya si-ibu admin bisa tahu siapa aja yng belum > register KRS > > > anak2, untk itu mohon pencerahanya saya menggunakan DB Access > bawaan VB > > > (ver. 7.0 ) SQL command-nya gimana ya mohon bimbingannya ? > > > > > > > > > Terima kasih > > > > coba gini: > > select NO_KRS, Nim from TBL001 where TBL001.No_KRS not in (select > no_KRS > > from TBL002) > > > > > > Untuk keluar dari millis ini, kirim email kosong ke: > [EMAIL PROTECTED] > > > Yahoo! Groups Links > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/k7folB/TM --------------------------------------------------------------------~-> Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Programmer-VB/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
