> 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/
