--- Hyuuga Neji <[EMAIL PROTECTED]> wrote:
> dear vbers, > saya mempunyai problem sebagai berikut > tabel 1 > kantong_order tanggal_akses jam_akses > P1111111 12/01/2005 12:00 > P1111112 13/01/2005 13:00 > P1111113 14/01/2005 15:00 > P1111114 14/01/2005 15:30 > Tabel2 > kantong_order tanggal_seharusnya_selesai > jam_seharusnya_selesai > P1111111 17/01/2005 17:00 > P1111112 18/01/2005 17:00 > P1111113 19/01/2005 17:00 > saya ingin melakukan query terhadap 2 tabel ini > yang hanya menghasilkan > kantong_order tanggal_askes jam_akses > P1111114 14/01/2005 15:30 > jadi saya ingin yang tampil HANYA yang tidak > mempunyai pasangan di tabel > tetangganya.., kira kira querynya bagaimana ya? > mohon pencerahannya.. > regards > neji > hmmm bukan nya tinggal : Select * from tabel 1 where kantong_order not in ( select kantong_order from tabel 2 ) __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------ 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/
