Coba pake' ini SELECT T1.NOMOR, T1.NAMA, T2.NAMA2 FROM TABLE_HEADER T1, TABLE_DETAIL T2 WHERE T1.NOMOR = T2.NOMOR AND T2.TGL = (SELECT MAX(TGL) FROM TABLE_DETAIL)
semoga membantu.. ----- Original Message ----- From: Èr1Ék To: [email protected] Sent: Thursday, August 17, 2006 2:49 PM Subject: [indoprog-vb] SQL Halow semua nya, sy ada pertanyaaan nih :D Contoh sy punya Tabel Header Detail Tabel Header No Nama 1 Nm1 2 Nm2 Tabel Detail Tgl No Nama2 1/10/2006 1 Nm11 1/11/2006 1 Nm12 1/12/2006 1 Nm13 1/9/2006 2 Nm21 1/12/2006 2 Nm22 Yg sy ingin kan hasil nya spt ini (ambil tgl terakhir nya sj) No Nama Nama2 1 Nm1 Nm13 2 Nm2 Nm22 Hal spt itu bisa gak yach (sl nya smp saat ini lom ketemu SQL nya :( ) ? tengkyu yach eriek [Non-text portions of this message have been removed] Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED] Bagi terjangkit virus lokal, zip virus tersebut dan kirim ke [EMAIL PROTECTED], kami akan membuat removalnya untuk anda. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indoprog-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/
