coba script ini mas:
select a.no,a.nama1,b.nama2
from header a,detail b
where a.no=b.no and b.tgl in (select max(tgl) from
detail);
semoga dapat membantu..
==Nando Gurning==
Y! [EMAIL PROTECTED]
On Thu, 17 Aug 2006 07:49:49 -0000
Èr1Ék <[EMAIL PROTECTED]> wrote:
> 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
>
>
>
========================================================================================
========================================================================================
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/
