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) > ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
