[belajar-access] Salam

Salam Access,

Alhamdulillah saya bisa gabung lagi karena beberapa bulan sebelumnya masalah di komputer saya. Mudah-mudahan saya dapat ilmu di sini.

Salam,

Aksan Kurdin <aksan.kurdin@gmail.com> Sent by: belajar-access@yahoogroups.com 04/12/2011 11:04 AM Please respond to belajar-access

To:        belajar-access@yahoogroups.com         cc:                 Subject:        Re: [belajar-access] Re:

 

pahami sub query.

select tb_siswa.id_siswa, tb_siswa.nama_siswa,
(select id_pembayaran from tb_pembayaran where id_siswa = tb_siswa.id_siswa order by id_pembayaran DESC) AS _id_pembayaran,
(select periode_bln from tb_pembayaran where id_siswa = tb_siswa.id_siswa order by id_pembayaran DESC) AS _id_pembayaran,
(select periode_th from tb_pembayaran where id_siswa = tb_siswa.id_siswa order by id_pembayaran DESC) AS _id_pembayaran
from tb_siswa


aksan kurdin



On 4/12/2011 10:00 AM, FAJAR N wrote:
 
Masih blm bisa Pak Aksan, ada warning dari system.

Utk lbh jelas ini sy sertakan contoh tabelnya dan query awalnya. Nah, query akhir yg diinginkan adl dg record yg dlingkari merah.

Terima kasih
Fajar

__._,_.___

SPAM IS PROHIBITED

Your email settings: Individual Email|Traditional
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch to Fully Featured
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe

__,_._,___