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