select h.no, h.nama, d.nama2
from tabelheader h
join tabeldetail d on h.no=d.no
where d.tgl=(select max(tgl) from tabeldetail x where h.no=x.no)
On 8/17/06, È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
__._,_.___
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Indonesia phone card | Programmer | Indonesia tour |
| Indonesia travel | Indonesia flower |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
__,_._,___
