:) pake sub query:
select noid, tanggal, harga, (select top 1 keterangan from tbl_1 where noid = tbl_2.noid) as keterangan from tbl_1 aksan kurdin On 2/20/08, Dwi Wuryantadi <[EMAIL PROTECTED]> wrote: > > ----- Original Message ----- > From: "Dwi Wuryantadi" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Wednesday, February 20, 2008 7:53 AM > Subject: [belajar-access] > > > > Mohon bantuannya > > Saya mempunyai data di dua tabel sebagai berikut: > > > > tbl_1 > > NoId; Tanggal; Keterangan > > a1 01-01-2008 Sabun Mandi > > a1 01-01-2008 Sabun Kecantikan > > > > tbl_2 > > NoId; Tanggal; Harga > > a1 01-01-2008 10.000 > > > > Ingin saya gabung dengan hanya mengambil keterangan di a1 record > > pertamamenjadi > > > > qry_1 > > NoId Tanggal Harga Keterangan > > a1 01-01-2008 10.000 Sabun Mandi > > > > Thanks b4 > > > > > > > > ___________________________________________________________ > > All New Yahoo! Mail – Tired of [EMAIL PROTECTED]@! come-ons? Let our > > SpamGuard protect > > you. http://uk.docs.yahoo.com/nowyoucan.html > > > > > > > > SPAM IS PROHIBITED > > Yahoo! Groups Links > > > > > > > > > > > > ___________________________________________________________ > All new Yahoo! Mail "The new Interface is stunning in its simplicity and ease > of use." - PC Magazine > http://uk.docs.yahoo.com/nowyoucan.html > > > > SPAM IS PROHIBITED > Yahoo! Groups Links > > > > -- Aksan Kurdin SPAM IS PROHIBITED Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/belajar-access/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/belajar-access/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> 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/
